Power cuts caused by database "suspicious", repair, some mistakes, but there is a table in the SQL 2008 can see, but don't delete,
Use DBCC CHECKDB, return current command "serious error occurred, should give up any possible results,"
Use DBCC CHECKTABLE, return "may be the structure is damaged, please run DBCC CHECKCATALOG,"
With DBCC CHECKCATALOG, didn't prompt error, return "DBCC execution is completed. If DBCC output the wrong information, please contact the system administrator,"

And found one of the table there is a problem,
The SELECT, DROP the table, all error
An error message "211, the level of 23, 51, line 1, the structure damage may occur, please run DBCC CHECKCATALOG,
Message 0, level 20, state 0, 0, current command has had the serious mistakes, should give up any possible results, "

CodePudding user response:

Reference: https://blog.csdn.net/kk185800961/article/details/109633086
If still not solve, can direct messages

CodePudding user response:

Or not, is still an error,

CodePudding user response:

Delete all index, try again,

If not yet, inserted into the backup table, see if you can:
Select *
Into new_bak_20201208
The from tableName with (nolock)