exec sp_dboption ‘dbname1‘,‘single user‘,‘true’
dbcc checkdb(‘dbname1‘)
dbcc checkdb(‘dbname1‘,REPAIR_FAST)
dbcc checkdb(‘dbname1‘,REPAIR_REBUILD)
dbcc checkdb(‘dbname1‘,REPAIR_ALLOW_DATA_LOSS)
exec sp_dboption ‘dbname1‘,‘single user‘,‘false’
原文：http://www.cnblogs.com/cb168/p/4188209.html