CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Jason Young
Jason Young

Reputation: 3753

How do I switch to a SQL Server Server Database that will exist after another command?

I can't get this script to run, because SQL management studio 2008 says the table "NewName" does not exist. However, the script's purpose is to rename an existing database, so that it does exist when it gets to that line. Ideas?

Use Master;

ALTER DATABASE OldName SET SINGLE_USER WITH NO_WAIT;
ALTER DATABASE OldName MODIFY NAME = NewName;

ALTER DATABASE NewName SET MULTI_USER;
Use NewName; --THIS LINE FAILS BEFORE THE SCRIPT EVEN RUNS!

Upvotes: 3

Views: 97

Answers (1)

Jon Seigel
Jon Seigel

Reputation: 12401

Add GO between the 2nd and 3rd ALTER DATABASE statements.

http://msdn.microsoft.com/en-us/library/ms188037.aspx

Upvotes: 7

Related Questions