Welcome to Dot Net World
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
Newer Posts
Older Posts
Home
Subscribe to:
Comments (Atom)