Reply To: How to rename SQL Server database?

Execute the following script to rename the database

USE master;
GO
EXEC sp_dboption MyDatabase, 'Single User', True
GO
EXEC sp_renamedb ' MyDatabase', ' MyDatabaseNew’
GO
EXEC sp_dboption MyDatabase, 'Single User', False
GO