Check this link from Jeff

http://www.sqlservercentral.com/articles/T-SQL/68467/

duplicate post

reply to this thread

http://www.sqlservercentral.com/Forums/Topic1322306-392-1.aspx#bm1326782

This will do the trick

DECLARE @d DATETIME = '1984-08-13 00:00:00.000'

SELECT CONVERT(NVARCHAR(10),@d,120)

Top 5 off the top of my head are

Red-Gate SQL Monitor

Idera Diagnostic Manager

Quest Spotlight

Quest Foglight

SQLSentry

All are differently priced and all have their similarities and differences, I would recommned downloading the...

Sounds like a catch all query

Please read through this

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

SELECT

U.UserName AS SubscriptionOwner,

C.Path AS ReportPath,

CONVERT(XML,S.ExtensionSettings) AS SubscriptionSettings,

S.EventType AS SubscriptionType,

CONVERT(XML,S.Parameters) AS ReportParameters,

S.DeliveryExtension AS DeliveryMethod,

Sc.Name AS ScheduleName,

Rs.ScheduleID

FROM

Subscriptions S

INNER JOIN

Users U

ON

S.OwnerID = U.UserID

INNER JOIN

Catalog C

ON

S.Report_OID = C.ItemID

INNER JOIN

ReportSchedule RS

ON

S.SubscriptionID = RS.SubscriptionID

INNER JOIN

Schedule Sc

ON

RS.ScheduleID...

It runs at the same time unless you say on the data source to use a signle threaded operation.

When you develop a report in BIDS it cache's the data of the initial run.

If you go into the solution folder you will see a number of rdl.cache or cache.rdl...

http://msdn.microsoft.com/en-us/library/ms186358.aspx

this should help you setup db mail

Take a look at the accidental DBA e-book (link in my signature below) for the blocking chapter (chapter 6).

Thats an Execute T-SQL Statement task, you need a Execute SQL task.

Sorry my bad, there is no parameter mapping option on that task, you will need to use the Execute SQL Task instead.

Change the select statement to

SELECT ? = MAX(PolicyID) FROM dbo.FactPolicy

Then in the paramter mappings of the task set the mapping to the variable as an output type, that should then...

Please can you read through the second link in my signature below on posting code and data for the best help.

We would need the DDL of the tables along with...

You wont be able to create a clustered index on them two columns as your primary key is already clustered.

You would first need to drop your primary key and re-create...