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-04-17 : 21:23:52
|
| Sira writes "Can you rename a database to an name that might have been used before and dropped? I get an error on that with sp_renamedb." |
|
|
dsdeming
479 Posts |
Posted - 2002-04-17 : 21:57:47
|
| I don't know of any reason you shouldn't be able to reuse the name of a database that's been dropped. However, if the database was merely detached, you need to be careful with your data and log filenames because the default names for the new database will be identical to those of the detached database. You'd have to explicitly specify unique file names for the new database.The easiest way to find out if the database was truly dropped is probably to query master..sysdatabases. |
 |
|
|
|
|
|
renaming databases