sql 语句如下 (将‘YINGMU ’改为自己的问题数据库名)
USE MASTER
GO
SP_CONFIGURE ALLOW UPDATES,1 RECONFIGURE WITH OVERRIDE
GO
ALTER DATABASE YINGMU SET EMERGENCY
GO
sp_dboption YINGMU, single user, true
GO
DBCC CHECKDB(YINGMU,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE YINGMU SET ONLINE
GO
sp_configure allow updates, 0 reconfigure with override
GO
sp_dboption YINGMU, single user, false
GO