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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-30 : 08:26:22
|
| Mark writes "Is there any concern I have to pay attention before I rename SQL server database name by issue command “sp_renamedb” ? After rename, will cause any data loss, include SP, Diagram, View, table, users, etc …?" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-30 : 13:00:06
|
| Shouldn't cause data loss, but there are some things to be aware of. It will break any code that references the database by name. It will break SPs that have a 'USE dbname' or a Server.dbname.owner.table reference.-Chad |
 |
|
|
|
|
|
Rename database name