16
Database '%.*s' is not marked suspect. You cannot drop it with DBCC.
This error occurs when you try to use dbcc dbrepair to drop a database that is not marked suspect. Only databases that have been marked suspect can be dropped using this command.
Databases are marked suspect in the following ways:
Adaptive Server marks a database suspect when some critical errors occur.
The Sybase System Administrator can mark a database suspect in order to drop it with the dbcc dbrepair command.
Use drop database to try to drop the database. If this fails, use the procedure described in “Dropping a database when drop database fails” in the chapter “Other Useful Tasks” in the most recent version of the Troubleshooting and Disaster Recovery.
All versions