Tuesday, May 5, 2009

Rename MSSQL Server Database Name

ERROR: The database could not be exclusively locked to perform the operation.

SOLUTION:

ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
SP_RENAMEDB ,
Go
ALTER DATABASE SET MULTI_USER -- set back to multi user
GO