Sorry! I have updated my previous comment which explains the changes that I made!

A little bit of formatting + fix 😉

You don't need to include the schema name when you call the OBJECT_ID function:

OBJECT_ID(N'dbo.mtzcus_2014_CoreMenuAuditDetails', N'U')

should be just

OBJECT_ID(N'mtzcus_2014_CoreMenuAuditDetails', N'U')

IF OBJECT_ID(N'mtzcus_2014_CoreMenuAuditDetails', N'U') IS NOT...

CREATE TABLE dbo.SCC (

Col1 VARCHAr(10),

Col2 INT,

Col3 INT,

Col4 TINYINT)

INSERT INTO dbo.SCC (Col1, Col2, Col3, Col4)

VALUES ('Test1', 3016482, 56395, 3),

('Test2', 5489108, 57921, 2),

('Test1', 3016482, 56395, 3),

('Test3', 8079081, 89302, 1),

('Test4', 8789080,...

Use Jeff's string splitter function?

Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]

You're welcome 😀

Just noticed you may want to change the size of your @Result variable to more than 10 characters as the version number you're checking is 12 characters long?

Here you go:

DECLARE @ServerName AS NVARCHAR(50)

SET @ServerName = <YOURSERVERNAME>

DECLARE @sql AS NVARCHAR(1000), @Result AS NVARCHAR(10)

SET @sql = 'SELECT @theResult = CAST(Result AS NVARCHAR(50)) FROM OPENQUERY([' + @ServerName + '],...

Assuming you have the restore job scheduled as a SQL Agent job then why not add an extra step where you call a single stored procedure that contains the code...

If the database is still attached to the SQL instance then you won't be able to delete it via windows explorer.

You can either delete the database from the SQL Server...

SQL Native Client

Professional SQL Server 2008 Internals and Troubleshooting

SQL Server MVP Deep Dives

SQL Server MVP Deep Dives 2

I love SQL Compare!

Great tools at reasonable prices for sure. However, be aware that some of the tools like the SQL Backup utility can only be used for one server...

Didn't get the job! Boohoo! :w00t:

In the end the guy with the more team leading experience got it.

Just goes to show, getting through the second stage doesn't mean job guaranteed!

2 minutes doesn't sound too bad considering it's performing so many scans on your ReportRecipients table!

The only alternative I can think of (and I'm not even convinced it will speed...

Firstly, I would recommend a quick read of the below as a refresher:

http://technet.microsoft.com/en-us/library/ms186992(v=sql.105).aspx

I would change your code to the below:

WHERE

( ct.AlertedDate between @startdate and @enddate OR ct.[Dispo] = @STdrp...

SSAS /SSRS and SSIS are merely free tools that Microsoft kindly gives us when we purchase their SQL Server software. You install the SQL Server engine - then you can...