Use dbcc dbrepair dropdb from the master database to drop a damaged database. No users, including the user running dbrepair, can be using the database when it is dropped.
The syntax for dbcc dbrepair is:
dbcc dbrepair (database_name, dropdb)
The Transact-SQL command drop database does not work on a database that cannot be recovered or used.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
