What a coincidence. Do you just light up a room when you walk...

The only credit I can take is that I found it on the net. I have used them in some code that I wrote.

...

You think that is sad. Here is my best story.

I once had a situation where a company called me up and asked me if I would be interested in...

Go Steve Go....

Forget about the fact that you have to write the EDJ for tomorrow. Tell us your story... How did you get the cushy job you have...

Actually that made me wonder what the record is? Or do we have to count only those posts that were about the OP topic 🙂 I would guess...

If nothing else cursors are painfully slow. They hold locks for extended periods causing other issues. If a set based solution is not available, the following is a...

FYI a way around the problem above.

Pass the object_ID of the table rather than the name..

...

@theTableID = object_id('tblTheTable')

...

select @theSQL = 'select id,name from ' + quotename(name)

from sys.tables where object_id =...

"with execute as owner" is the best way around that issue, but be very careful that you can't use that procedure to incorporate SQL INJECTION.

There are some great...

This is a good time to post some utilities that I have used before. There are functions to return several SQL Locations.

http://sqldev.net/misc/SQLLocationFunctions.htm

I'm thinking that the issue is that the name of the DB has "Special characters" in the name.

Just place []'s around the Name

CREATE DATABASE [This Is a Stupid...

After looking at the post... srcTable and destTable are confusing to say the least. :blush: Also, obviously you will need to "Create" it before you alter it.

Forgive this for being thrown together in about 10 min.

I suspect this is what the OP is trying to do:

ALTER PROCEDURE bobTest

@srcTableID INT,

...

Another example (sorry didn't use yours) This also detects Nothing to do situation

DECLARE @status BIGINT

BEGIN TRANSACTION

BEGIN TRY

DELETE

FROM [master].[dbo].[tblAppLog]

WHERE tblAppLog.entry_num = @EntryID

SELECT @status...

There are many reasons why you want to move the System Databases, and I agree with all of them.... However;

Rarely do they need restored, they are often much easier to...

J (3/12/2008)

I would be weary about using the social security number, especially if you have an employee code or number. ssn should in my humble view used only for matters...