USE master Go sp_dboption '数据库名','single user','true' Go DBCC CHECKDB('数据库名',REPAIR_ALLOW_DATA_LOSS) Go USE 数据库名 Go exec sp_msforeachtable 'DBCC CHECKTABLE(''?'',REPAIR_ALLOW_DATA_LOSS)' exec sp_msforeachtable 'DBCC DBREINDEX(''?'')' Go sp_dboption 'ftyouth','single user','false' Go
USE master
Go
sp_dboption '数据库名','single user','true'
Go
DBCC CHECKDB('数据库名',REPAIR_ALLOW_DATA_LOSS)
Go
USE 数据库名
Go
exec sp_msforeachtable 'DBCC CHECKTABLE(''?'',REPAIR_ALLOW_DATA_LOSS)'
exec sp_msforeachtable 'DBCC DBREINDEX(''?'')'
Go
sp_dboption 'ftyouth','single user','false'
Go
dbcc checktable('表',REPAIR_REBUILD)