sybase的官方说法: If a database has a large enough number of inconsistencies,the server may consider the databASE to be corrupt。In this situation,the database cannot be dropped wITh the drop database command
The database can be dropped only with dbcc dbrepair Syntax:
dbcc dbrepair(dbname,dropdb)
Example:
dbcc dbrepair(pubs2,dropdb)
Note: sa_role is required to run dbcc dbrepair.
3.如果还不行,那么就这样
sp_configure "allow update",1
update sysdatabases set status=320 where name = yourdatabasename
Server Message: Number 3751, Severity 16
Server 'CBS', Line 1:
Cannot drop the temporary database 'saptempdb'. Either the database is a member of a group or there are bindings to this database. 作者: andkylee 时间: 2015-09-23 14:10 回复 7# tanrj