I had this last year on a v6.5 server and rebuilding the clustered index was
the solution which did not work. We had to call MS and get help BCP'ing the
data out and rebuilding the table. I would try the index rebuild and then
(if you can) a BCP out and back in to a new table. If you do not get all
rows out with the BCP, call MS. It's not worth messing around with this.
Quote:> We received the following error in SQL 7.0 SP2:
> Error: 644, Severity: 21, State: 1
> Could not find the index entry for RID
> '36ef73000300101a0495654525830313532353437' in index page (1:99403),
> index ID 2, database 'CTP'.
> Per the directions in BOL, I ran dbcc checkdb on the database and that
> always comes back reporting no errors. I have not yet attempted to run
> any repairs on the database since the dbcc checkdb isn't finding any.
> Should I go ahead and try running repairs anyway?