Check is the data table [UFTmpTable_33565914_5231678149313212099] there is a problem, don't know how to generate, this watch is useless, tried to remove it prompts table does not exist or without permission;
Checklist sys. Objects, sys. Indexes, find sys. There is data in objects, but the sys. The indexes of no data, so the consistency of mistakes,
Trying to delete records from sysobjects, prompt "are not allowed at impromptu system directory updates,"
The search on the net, is probably said above sql2000 version does not support modifying system tables, really don't know how to deal with, the great god, please help to check it out!
CodePudding user response:
It seems not a table, and a statistical information, can consider to delete all the index and statistical information on the table, and then rebuild the index,Note that the backup
CodePudding user response:
Is a table, I can find this in the resource manager table:I try to check the table of statistics, check less than, index, fields are not easy, only have a record in table sysobjects:
I just want to delete this record, should not be consistency error!
CodePudding user response:
The alter database DbName set single_user with rollback immediateGo
DBCC checkdb (DbName, repair_allow_data_loss)
Go
The alter database DbName set multi_user
Go
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Sql2000 above can also modify the system tables, just login with DAC
Suggest use DBCC to fix good
CodePudding user response:
DBCC checkdb (DbName, repair_allow_data_loss)Is such repair, not line, an error, error is fixed times above
CodePudding user response:
If you try to auto repair,Suggest a new empty database, the useful data import new database, then swap 2 database name.