Query: EXEC SP_RENAMEDB N'OLD_DB', N'NEW_DB';
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';