Category: SQL

Quick note about how to rename an SQL Server database that could not be exclusively locked (because it has open connections to it):

ALTER DATABASE currentDbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
EXEC sp_renamedb N'currentDbName', N'newDbName';
GO
ALTER DATABASE newDbName SET MULTI_USER WITH ROLLBACK IMMEDIATE;
GO