How to Change Database Name

Satyapriyanayak
Posted by Satyapriyanayak under Sql Server category on | Points: 40 | Views : 984
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"

Comments or Responses

Login to post response