We have just upgraded our database server to a 14 processor ultrasparc and are now having a problem with one of the tables in the database.
We dumped the database and reloaded it on the new machine and now one of the tables is giving us error 625 (Could not retrieve row from logical page %ld via RID because the entry in the offset
table for that RID is less than or equal to 0.) whenever we try to update it from a trigger in another table in the database. DBCC shows no errors and we have even dropped the table and BCP'd the data back into it but still the error occurs.
We are also getting the occasional error 693, 625, and 605 but again only on this table even after we have recreated it.
Has anyone any ideas of what this can be and how to fix it?