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.
| 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 |
|
|
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' |
 |
|
|
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 databaseMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|