• One of the table is corrupt and I could not find SQL 6.5 command to fix it.

    Not sure if an index or data issue

    Error messages

    Msg 624, Level 20, State 1

    Attempt to retrieve row from page via RID failed because the requested RID has a higher number than the last RID on the page. Rid pageid is 0x6 and row num is 0xffffed7c.Page pointer = 0x24c19000, pageno = 2814043, status = 0x101, objectid = 1968010042, indexid = 0.

    The SQL Server is terminating this process.

    DBCC CHECKTABLE(TABLE1)

    Checking TABLE1

    The total number of data pages in this table is 6231.

    Table has 33443 data rows.

    Msg 625, Level 20, State 1

    Could not retrieve row from logical page 2814038 via RID because the entry in the offset table (= 0) for that RID (= 6) is less than or equal to 0.

    DBCC execution completed. If DBCC printed error messages, see your System Administrator.