(0.007 seconds) Articles (1327) /67 Next>> Last >| how to automatically run a report with parameters and email the report based on 0 1287 (9/12/2010 2:16:26 PM) Lior_Me 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... Finding unused objects 1 2310 (9/12/2010 8:03:48 AM) Utf 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? ... Possible problem with differential backups 7 1014 (9/8/2010 5:30:35 PM) JoshBond 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... SQL IN 3 1014 (9/10/2010 8:03:05 PM) kpg 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... MS SQL 2005 to SDF 0 1108 (9/10/2010 6:38:41 PM) Brian 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 ... Mirroring: High safety. (Data loss question). 1 1018 (9/10/2010 9:40:35 AM) ben 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... Locking in merge statement 2 1608 (9/10/2010 11:52:46 AM) schaf 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...