- 论坛徽章:
- 0
|
本帖最后由 redwaves 于 2010-07-14 17:36 编辑
回4楼
按照您的指导作了还是不成功
1> use master
2> go
1> dbcc traceon(3604)
2> go
00:00000:00012:2010/07/14 17:15:35.75 server DBCC TRACEON 3604, SPID 12
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
1> dbcc dbrepair('xhb',dropdb)
2> go
Msg 2573, Level 16, State 1:
Server 'AS5XHB', Line 1:
Database 'xhb' is not marked suspect. You cannot drop it with DBCC.
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
1>
按提示需要将数据库xhb标记为suspect
查过手册提示:
After You Execute sp_marksuspect
Once the procedure is created successfully, updates to the system catalog should be immediately disabled as follows:
1> sp_configure "allow updates", 0
2> go
Syntax
sp_marksuspect database_name
Example
1> sp_marksuspect PRODUCTION
2> go
通过sp_help没有找到sp_marksuspect命令,版本12.5.4
还有别的办法吗? |
|