数据库质疑修复(SUSPECT)总结,DBCC报错

-- A list of all of the Foreign Keys and the table namesDECLARE foreignKeyCursor CURSOR FORSELECT aint_name AS FK_Name, _name AS FK_Table FROM INFORMATION_NTIAL_CONSTRAINTS ref INNER JOIN INFORMATION__CONSTRAINTS fk ON aint_name =aint_name ORDER BY _name, aint_name

OPEN foreignKeyCursor

FETCH NEXT FROM foreignKeyCursor INTO @foreignKeyName, @tableNameWHILE ( @@FETCH_STATUS = 0 ) BEGIN IF @disable = 1 SET @sql = 'ALTER TABLE [' + @tableName + '] NOCHECK CONSTRAINT [' + @foreignKeyName +']' ELSE SET @sql = 'ALTER TABLE [' + @tableName + '] CHECK CONSTRAINT [' + @foreignKeyName + ']' PRINT 'Executing Statement - ' + @sql EXECUTE(@sql) FETCH NEXT FROM foreignKeyCursor INTO @foreignKeyName, @tableName END

CLOSE foreignKeyCursor

DEALLOCATE foreignKeyCursor

Go

DECLARE @disable BITset @disable= 0 DECLARE @sql VARCHAR(500), @tableName VARCHAR(128), @tableSchema VARCHAR(128)

-- List of all tables DECLARE triggerCursor CURSOR FOR SELECT _NAME AS TableName, _SCHEMA AS TableSchema FROM INFORMATION_ t ORDER BY _NAME, _SCHEMA

OPEN triggerCursor

FETCH NEXT FROM triggerCursor INTO @tableName, @tableSchema WHILE ( @@FETCH_STATUS = 0 ) BEGIN IF @disable = 1 SET @sql = 'ALTER TABLE ' + @tableSchema + '.[' + @tableName + '] DISABLE TRIGGER ALL' ELSE SET @sql = 'ALTER TABLE ' + @tableSchema + '.[' + @tableName + '] ENABLE TRIGGER ALL' PRINT 'Executing Statement - ' + @sql EXECUTE ( @sql ) FETCH NEXT FROM triggerCursor INTO @tableName, @tableSchema END