Rename database sql server using T-SQL

Rename database SQL Server using T-SQL

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';



ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.
^