Could not find the index entry for RID - URGENT PLEASE

[DavidJA]

Hey all;

My DB has started giving this error:
Server: Msg 644, Level 21, State 3, Line 1
Could not find the index entry for RID '16b823ff247f1786489b7894321e86dff2000040400000000000000000000000000' in index page (1:86393), index ID 0, database 'EzyBoard'.

Connection Broken

when I run a query with a particular parameter.

http://ddart.net/mssql/sql2000/html/trblsql/tr_reslsyserr_1_23sk.htm

says to fix the problem I need to find the table and index from the index page number (86393);

So the question is, how to I convert an index page number to the name of a table and index?

 

[tlbroadbent]

Have you run DBCC CheckDB on the database to find and correct problems. The "Database Consistency Checker" should report index problems and may correct them. You can then drop and recreate the indexes.

Running DBCC dbreindex to rebuild all indexes on all tables in the database may also correct the problem. See BOL for details. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm