Web developers notes,programming tutorials.

Alternate method for renaming a Database in Sql server 2005

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

This entry was posted on Thursday, March 6th, 2008 at 10:55 am and is filed under ms sql server 2005. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.