Locating a table using index page

Hello,

I not exactly sure how to determine the table when given the following
information:

--
Could not find the index for RID '999999' in index page
('1:99999999'), index id ), database (whatever).
--

Can you someone tell how I use the system tables to determine what
table this index corresponds to? I'm assuming I used sysindexes and
sysobjects somehow.

Thanks in advance,

JGB_DBA"jgb_dba" <jgb_dba@.yahoo.com> wrote in message
news:ab559e7c.0407260912.1addc564@.posting.google.c om...
> Hello,
> I not exactly sure how to determine the table when given the following
> information:
> --
> Could not find the index for RID '999999' in index page
> ('1:99999999'), index id ), database (whatever).
> --
> Can you someone tell how I use the system tables to determine what
> table this index corresponds to? I'm assuming I used sysindexes and
> sysobjects somehow.
> Thanks in advance,
>
> JGB_DBA

It looks like you may a corrupt database - see "Error 644" in Books Online
for details on how to correct it. You didn't give any information about your
MSSQL version or when the error occurs, but if you're using 2000 without the
latest servicepack, then you might be seeing one of these issues:

http://support.microsoft.com/?kbid=834290
http://support.microsoft.com/?kbid=300194

Simon