The first GO ends your batch. That is what is causing your problem. Try this:

DECLARE @SQLCmd nvarchar(4000);

set @SQLCmd = '

ALTER DATABASE test SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

SP_RENAMEDB test,test_Old

GO

ALTER...

The first GO ends your batch. That is what is causing your problem. Try this:

DECLARE @SQLCmd nvarchar(4000);

set @SQLCmd = '

ALTER DATABASE test SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

SP_RENAMEDB test,test_Old

GO

ALTER...

Thank you. That explaination is sure to help someone else out in a similar situation. It will provide them with a direction to look at things in their...

Perfect! Just the change I made in my copy here at home. Of course the 4 minutes it took on my part would have saved you quite a...

Since you came looking for help, forum etiquette would have tell all...

And, for the record, I have made a simple correction to my code and have the results you are expecting: 3 and 6.

Show me what you can do with the...

ahmet erispaha (6/23/2009)

---

Thank you RBarry and Lynn for your solutions. I apologize for the mismatch in the table name between DDL and DML for table InsuranceClaim. I was...

Give the following a try. If not completely successful, let us know what issues you run into.

Code is in the attachment. Once again I just can't seem to...

When you applied the last transaction log, did you use the WITH RECOVERY clause or did you use the WITH NORECOVERY clause?

If the latter, try RESTORE DATABASE dbname WITH RECOVERY

lmu92 (6/23/2009)

---

Hi Lynn,

would you mind quoting the...

Carl Federl (6/23/2009)

---

Sorry about the delay,but the NTFS decided to misbehave on my business laptop and spent yesterday getting windows re-installed.

First, the term "Triangle Join" is a wonderfull term that...

It would help if you let is know what you have tried so far to solve the task at hand and where you are having problems.

We are all volunteers on...

You can't disable Windows Authentication. The best you can do is not grant access to your servers to windows user or group accounts. If you don't authorize them...

Roy Ernest (6/23/2009)

---

Hey Barry, That movie star , what is his name Redford?? He looks just like you...:-) He must have been one pleased man to look like you... Just...

You really must be kidding, right? This is your code, why should we do your work for you?...