SQL SERVER – 2005 – Use ALTER DATABASE MODIFY NAME Instead of sp_renameDB to rename | Journey to SQL Authority with Pinal Dave

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… Continue Reading...

Source: SQL SERVER – 2005 – Use ALTER DATABASE MODIFY NAME Instead of sp_renameDB to rename | Journey to SQL Authority with Pinal Dave