Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Can a Database be renamed

Author  Topic 

Camper66
Starting Member

13 Posts

Posted - 2009-04-15 : 12:52:35
Hi again and thank you in advance. Can a database be rename ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-04-15 : 13:02:09
yup...it can be..see below

http://www.mssqltips.com/tip.asp?tip=1122
Go to Top of Page

sital
Yak Posting Veteran

89 Posts

Posted - 2009-04-16 : 02:33:32
Yes It can be renamed by using the following syntax:

sp_renamedb 'Existing Databse Name','New Name for the Database'
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-16 : 03:47:16
Also be aware that you should change the connection string if any applications are bound to that database

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -