The index entry for row ID was not found in index ID 5

The index entry for row ID was not found in index ID 5

Post by Jeffre » Thu, 04 Sep 2003 08:56:59


When I am trying to do an update on my table "Table1", I
got the following errors:

The index entry for row ID was not found in index ID 5, of
table 85575343, in database 'Client'..

I tried DBCC DBreindex on that index, dropping it and
recreating it, but still the same error.

Any clue.

Thank you very much.
 
 
 

The index entry for row ID was not found in index ID 5

Post by Dinesh.T. » Thu, 04 Sep 2003 23:08:52

Jeff,

Try a DBCC CHECKDB or DBCC CHECKTABLE at offpeak times.

--
Dinesh.
SQL Server FAQ at
http://www.yqcomputer.com/