|
|
|
SSC Journeyman
 
Group: General Forum Members
Last Login: Friday, March 12, 2010 7:51 AM
Points: 97,
Visits: 36
|
|
I have a weird issue.
Here are the stmts that I have run in order.
dbcc checktable table1 - no errors
alter table table1 add version varchars(15) null; - no errors
update table1 set version = '1.0.0.1'; - no errors
dbcc checktable table1 - ERRORS
ERRORS:
Msg 2537, Level 16, State 24, Line 1
Table error: object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 49193006989312 (type In-row data), page (1:237), row 0. The record check (valid record length) failed. The values are 271 and 267.
Msg 8929, Level 16, State 1, Line 1
Object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 49193006989312 (type In-row data): Errors found in off-row data with ID 53411840 owned by data record identified by RID = (1:237:0)
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 71825312068206592 (type LOB data). The off-row data node at page (1:343), slot 0, text ID 53411840 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 71825312068206592 (type LOB data). The off-row data node at page (1:343), slot 1, text ID 53477376 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 71825312068206592 (type LOB data). The off-row data node at page (1:343), slot 2, text ID 53542912 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 71825312068206592 (type LOB data). The off-row data node at page (1:343), slot 3, text ID 53608448 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 71825312068206592 (type LOB data). The off-row data node at page (1:343), slot 4, text ID 53673984 is not referenced.
There are 1 rows in 1 pages for object "TABLE1".
I found these two KBs on MS's website:
http://support.microsoft.com/kb/832437/en-us
http://support.microsoft.com/kb/872842/en-us
Another oddity with this is that I can add the column and run the update stmt to another table, and there is no error.
I was able to correct this by doing a dbcc checktable (table1, REPAIR_ALLOW_DATA_LOSS).
Any ideas why this could be happening?
Thanks,
Matt
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040,
Visits: 1
|
|
| No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
|
|
|
|
