|Message:||Database ‘%.*ls’ is not marked suspect. You cannot drop it with DBCC.|
|In earlier versions of SQL Server, DBCC DBREPAIR was used to drop databases that were suspect. To use DBCC DBREPAIR to drop a database, the suspect status must be true for the specified database.
Important DBCC DBREPAIR is included in SQL Server 2000 for backward compatibility only. It is recommended that you use DROP DATABASE to drop damaged databases. In a future versions of SQL Server, DBCC DBREPAIR may not be supported.
|To see if a database has been marked suspect, execute the following statement (replace ‘MyDatabaseName’ with the actual database name):
SELECT DATABASEPROPERTYEX( ‘MyDatabaseName’ , ‘Status’)
To drop a suspect database, use the DROP DATABASE command.