how to automatically run a report with parameters and email the report based on 0 483 (9/12/2010 2:16:26 PM)
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 of the report which belongs to each user, to that user's ema...
Lior_Me

Finding unused objects 1 1071 (9/12/2010 8:03:48 AM)
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_stats Is there a DMV to have this data about a View? ...
Utf

Possible problem with differential backups 7 242 (9/8/2010 5:30:35 PM)
Hi all, I have a 170GB OLTP database that only processes INSERTs and SELECTs, no UPDATEs or DELETEs. I add about 1.8GB of data every day, as verified with my transaction log backups taken every 15 minutes. A...
JoshBond

SQL IN 3 283 (9/10/2010 8:03:05 PM)
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 MyTable WHERE MyField IN ("Value1","Value2","Value3") MyFi...
kpg

MS SQL 2005 to SDF 0 302 (9/10/2010 6:38:41 PM)
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 available to do this or can it be done thru SQL Server Management ...
Brian

Mirroring: High safety. (Data loss question). 1 243 (9/10/2010 9:40:35 AM)
This is a multi-part message in MIME format. ------=_NextPart_000_0006_01CB50DC.FB9E3DB0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hello Reader, F...
ben

Locking in merge statement 2 713 (9/10/2010 11:52:46 AM)
Hi All, I have a table which contains some status information. Table1 (device varchar(200) primary key, NumberOfUsage int) Now I have a store procedure in which I would like to insert new devices, if they...
schaf