Day 30 More Fatal Errors and BUGs
Msg 5242, Level 22, State 1, Line 1
An inconsistency was detected during an internal operation in database ‘MyCorruptDatabase’(ID:12) on page (1:34923). Please contact technical support. Reference number 4.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute (object_id=xxx) of row (object_id=x,column_id=y) in sys.columns does not have a matching row (object_id=xxx) in sys.objects.
*Paul Randal has shown us how to correct these kind of problem, but PLEASE NO ONE SHOULD TRY THIS IN PRODUCTION.
Msg 8967, Level 16, State 216, Line 1
An internal error occured in DBCC which prevented further processing. Please contact Product Support.
Error: 8624, Severity: 16, State: 1 Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.
This issue appears to be related to the fact database compatibility is set to 80. I have filed a product bug for tracking purpose
Setting database compatibility to be 90 resolved the issue
When you have foreign keys more the 253 and if you want to delete record, you will get below error:
Msg 8621, Level 17, State 2, Line 1 The query processor ran out of stack space during query optimization. Please simplify the query
It’s a BUG in sql server
Msg 407, Level 16, State 1, Line 1
Internal error. The string routine in file e:\sql10_main_t\sql\common\dk\base\src\dstreambase.cpp, line 269 failed with HRESULT 0x8007007a.
The complete list of connect – BUGs can be found here:
Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:xxx) in object ID xxx, index ID 1, partition ID x, alloc unit ID xxxx (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID x, index ID 1, partition ID xx, alloc unit ID xxx (type In-row data). Keys out of order on page (1:xxxxx), slots x and x.
To overcome this run ALTER INDEX instead of DBCC REINDEX .