Msg 2537 & 8964 on SQL Server 2005

  • 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

  • This was removed by the editor as SPAM

  • Fixed the same issue by rebuilding indexes.

    DBCC DropCleanBuffers

    go

    DBCC FreeProcCache

    go

    DBCC DropCleanBuffers

    go

    exec sp_updatestats

    go

    EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"

    GO

  • Hi ,

    The KB articles are referring to SQL 2000. Please post the full build number for your SQL Server 2005.

    It is difficult to answer without a close look at the table and pages structures. Could you post the DDL of the table so we can try to reproduce the problem, plus the following:

    [font="Courier New"]

    dbcc ind('<base>','table1',-1)

    dbcc traceon(3604)

    dbcc page(<dbid>,1,237,3)

    dbcc page(<dbid>,1,343,3)[/font]

    in attached files ?

    Thx,

    David B.

    David B.

  • Forget it, I didn't see the timestamp in the main post :-D. I guess the pages are long gone now...

    David B.

    David B.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply