how to automatically run a report with parameters and email the report based on Lior_Me 0 262
Hi all, I have a report which uses a username as an input parameter. I need to schedule the report to run automatically and email only the page o...

Finding unused objects Utf 1 564
Using the following DMV I get to know which of the objects in the DB is in use dm_exec_trigger_stats, dm_exec_procedure_stats, dm_db_index_usage_stat...

SQL IN kpg 3 191
Hi all, Using ASP.NET, SQL SVR Express 2008 I want to use IN to select records that have one of a list of values like this: SELECT * FROM M...

MS SQL 2005 to SDF Brian 0 179
I want to convert a MS SQL 2005 Database to sdf (Compact), and include all the tables, views and stored procedures. Is there a good tool availabl...

Locking in merge statement schaf 2 399
Hi All, I have a table which contains some status information. Table1 (device varchar(200) primary key, NumberOfUsage int) Now I have a store pro...

Mirroring: High safety. (Data loss question). ben 1 149
This is a multi-part message in MIME format. ------=_NextPart_000_0006_01CB50DC.FB9E3DB0 Content-Type: text/plain; charset="Windows-1252" Conte...

SQL 2008 linked server to VFP 7.x tables?? tom12010 0 230
Does a good reference or tutorial exist for this topic?? We only need READ access from SQL 2008 to the VFP tables -- various select queries for re...

Maintenance Plan - General beginner questions Utf 4 236
Morning, I am creating my first maintenance job today and I have some general questions about the order of steps regarding the db and t-logs. I a...

SQL help Jami 1 195
Dear All Sql 2000 following is DDL and sample data CREATE TABLE #tmp ( Fname VARCHAR(20), lname varchar (10), Status char(1) )...

Log Shipping and backups GiJeet 1 252
Hello, I've read where once you setup log shipping in SQL2008 you can't take any additional backups from your primary server. What's with this? We...