What causes the “Table error” when I execute a script?
I used Management Studio Express to generate a script to alter a table. The script (as generated by Management Studio Express) changes the table by creating a temporary table, dropping the old table and then renaming the temporary one to replace the old one.
The script fails on one instance of the database with the error message:
What does it mean? What can possibly cause it? How can I solve it?
The script fails on one instance of the database with the error message:
Table error: Page (1:6270). Test (offset + len < PAGESIZE) failed. Slot 72, offset 0x11a8 is invalid.
What does it mean? What can possibly cause it? How can I solve it?
EvilPostIt
Could you do a DBCC CHECKDB on the database that this table exists within as it sounds like corruption.
ASKER
Okay the lines of interest I get from DBCC CHECDB is this: Msg 8978, Level 16, State 1, Line 2
What does it mean? What can be posssible causes of DB corruption in MS SQL?
Table error: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Page (1:58) is missing a reference from previous page (1:6270). Possible chain linkage problem.
Msg 8928, Level 16, State 1, Line 2
Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data): Page (1:6270) could not be processed. See other errors for details.
Msg 8976, Level 16, State 1, Line 2
Table error: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Page (1:6270) was not seen in the scan although its parent (1:111) and previous (1:6271) refer to it. Check any previous errors.
Msg 8944, Level 16, State 17, Line 2
Table error: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data), page (1:6270), row 61. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 69 and 68.
Msg 8944, Level 16, State 17, Line 2
Table error: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data), page (1:6270), row 61. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 69 and 68.What does it mean? What can be posssible causes of DB corruption in MS SQL?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Any luck with this?
Out of interest what was the outcome in the end?