MSSQL2000数据库损坏修复

use   master  
go  

exec sp_configure   'allow updates',1 reconfigure with override  
go    

update sysdatabases set status=-32768 where name='A2014'
go

exec sp_dboption 'A2014','dbo use only','false'  
GO

exec sp_dboption 'A2014', 'single user', 'true'
go    

dbcc checkdb('A2014', repair_fast)
go

update sysdatabases set status =28 where name='A2014'
go

exec sp_configure 'allow updates', 0 reconfigure with override  
go

exec sp_dboption 'A2014', 'single user', 'false'
go