Welcome to the SSC Community. We frequently go off on tangents from the original question, but usually those tangents are related in some way with the topic (unless it...

Looks like he'd have deleted his posts if he could have. Doesn't help, however, where those posts had been quoted.

As it appears you were provided several approaches to solve your problem, which one did you select?

You may want to spend some time reading BOL (Books Online, the SQL Server Help System).

Change SP_RENAMEDB to EXEC SP_RENAMEDB

Well, its your code. What was else for? If you don't need it, drop it.

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...