Post reply

Chechtable

  • August 15, 2007 at 9:56 am

    #373275

    Ran dbcc checktable and got an error (below).  Using this info, is there a way to determine which records are being referenced in the error messages?

    Msg 2570, Level 16, State 3, Line 1

    Page (3:9338), slot 115 in object ID 741577680, index ID 0, partition ID 72057594040025088, alloc unit ID 72057594046382080 (type "In-row data"). Column "ColumnValue" value is out of range for data type "sql_variant". Update column to a legal value.

    Msg 2570, Level 16, State 3, Line 1

    Page (3:9338), slot 117 in object ID 741577680, index ID 0, partition ID 72057594040025088, alloc unit ID 72057594046382080 (type "In-row data"). Column "ColumnValue" value is out of range for data type "sql_variant". Update column to a legal value.

    Thanks

  • August 15, 2007 at 10:06 am

    #727110

    I already found a KB articule that should help me, thanks.

    KB: http://support.microsoft.com/kb/923247

  • August 15, 2007 at 1:49 pm

    #727178

    The above mentioned KB was very helpful in identifying my data issues and helping me correct them.

Viewing 3 posts - 1 through 2 (of 2 total)

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