how to automatically run a report with parameters and email the report based on01325 (9/12/2010 2:16:26 PM) Lior_MeHi 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 objects12344 (9/12/2010 8:03:48 AM) UtfUsing 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 backups71048 (9/8/2010 5:30:35 PM) JoshBondHi 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 IN31057 (9/10/2010 8:03:05 PM) kpgHi 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 SDF01133 (9/10/2010 6:38:41 PM) BrianI 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).11042 (9/10/2010 9:40:35 AM) benThis 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 statement21636 (9/10/2010 11:52:46 AM) schafHi 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...