By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,750 Members | 1,456 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,750 IT Pros & Developers. It's quick & easy.

Locating a table using index page

P: n/a
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
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"jgb_dba" <jg*****@yahoo.com> wrote in message
news:ab**************************@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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.