Question

sql 2000 数据库置疑的解决方法

Answer 1

USE MASTER
GO

SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO

UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='AIS20090521094413'
Go

sp_dboption 'AIS20090521094413', 'single user', 'true'
Go

update sysdatabases set status =28 where name='AIS20090521094413'
Go

sp_configure 'allow updates', 0 reconfigure with override
Go

sp_dboption 'AIS20090521094413', 'single user', 'false'
Go

DBCC CHECKDB('AIS20090521094413')
GO
AIS20090521094413 替换成你数据库的名字、 将以上语句在查询器里面执行。