Commands We Can Use To Rename A Database In SQL Server 2008

Question

How we can rename a database in SQL Server 2008 ?

Satyapriya Nayak · Answer

http://www.mssqltips.com/sqlservertip/1891/best-practice-for-renaming-a-sql-server-database/ http://blog.sqlauthority.com/2007/07/13/sql-server-2005-use-alter-database-modify-name-instead-of-sp_renamedb-to-rename/

Sandeep Singh Shekhawat · Answer

By SQL query ALTER DATABASE MyOldDb MODIFY NAME = MyNewDb Here MyOldDb : It is already exist database which name will be change. MyNewDb : It is new name of database which we will give to database OR By store proceudre you cann use system store procedure which is sp_renamedb Like EXEC sp_renamedb 'MyOldDb' 'MyNewDb' Here MyOldDb : It is already exist database which name will be change. MyNewDb : It is new name of database which we will give to database

Vishnujeet Kumar · Answer

hi Varshikause this code USE master; GO ALTER DATABASE Modify Name = ; GO http://msdn.microsoft.com/en-us/library/ms174269(v=sql.100).aspx