How to change Database name in SQL Server?

 Posted by Raja on 9/8/2008 | Category: Sql Server Interview questions | Views: 18865

Use following code

Supported in SQL Server 2000 and 2005
exec sp_renamedb "test", "test1"

Supported in SQL Server 2005 and later version
ALTER Database "test1" Modify Name="test"

Asked In: Microsoft | Alert Moderator 

Comments or Responses

Login to post response