Anil Singh | Code-sample.com

Query:  EXEC SP_RENAMEDB N'OLD_DB' , N'NEW_DB' ; When we execute SP_RENAMEDB sometime getting error messages. Error :   The database could not be exclusively locked  to perform the operation in SQL Server. The solution of above error to rename database SQL Server T-SQL USE [MASTER] ; GO ALTER DATABASE [OLD_DB] SET MULTI_USER   WITH ROLLBACK IMMEDIATE ; GO EXEC SP_RENAMEDB N'OLD_DB' , N'NEW_DB' ;