That's disappointing.

Okay, that resolved that error, thank you. I am still getting the following error"

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '@DBName'.

Thank you,

David

Happy to hear you are finding it useful.

This issue has been resolved. It turns out all I needed to do was grant access to the Catalog schema.

No I have not. Do you have examples?

The merge would be based on a single unique id. I am deleting millions of records from a table that has 150+ million records in it. This will...

Thank you for these great solutions.

David

Sachin, this worked very nicely. Thank you for this great solution.

David

I have considered that. I will try it. Thank you!

I had the columns named incorrectly. Now I get me result set back, but I need to change limit_id_1 ... limit_id_9 to another value based on a case statement....

Sachin, thank you for you solution. I am modifying it to use joins from several tables instead of a single table as in the initial illustration. Here is...

Sorry, I should have stated that they will not always be the same. Thank you.

This is a basic helpful script. I just added comma formatting to make it easier to read. Thank you.

SELECT

Name

, Filename

, convert(varchar, cast(convert(decimal(12,2),round(size/128.000,2)) as money), 1) as FileSizeMB

, convert(varchar,...

That is a great point! I have the following similar version for those interested.

USE [master]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_whom1]') AND type in (N'P',...

This script is used for tracking blocking issues or just monitoring sessions on any database server.

Cheers