SQL Server – 2005 – Use Alter Database Modify Name Instead of sp_renameDB to rename

To rename database it is very common to use for SQL Server 2000 user :
EXEC sp_renameDB 'oldDB','newDB'
sp_renameDB syntax will be deprecated in the future version of SQL Server. It is supported in SQL Server 2005 for backwards compatibility only. It is recommended to use ALTER DATABASE MODIFY NAME instead. New syntax of ALTER DATABASE MODIFY NAME is simple as well.

/* Create Test Database */CREATE DATABASE Test
GO/* Rename the Database Test to NewTest */ALTER DATABASE Test MODIFY NAME = NewTest
GO/* Cleanup NewTest Database
Do not run following command if you want to use the database.
It is dropped here for sample database clean up. */DROP DATABASE NewTest
GO