Could not find the index entry for RID

WHen I run a simple query against a table I get the
following error:
Could not find the index entry for
RID '163939393034313038342020202020205041313130332020202020
203030333431332020202036000500' in index page (1:65918),
index ID 0, database 'MYDATABASE'."
What's the reason?|
| WHen I run a simple query against a table I get the
| following error:
|
| Could not find the index entry for
| RID '163939393034313038342020202020205041313130332020202020
| 203030333431332020202036000500' in index page (1:65918),
| index ID 0, database 'MYDATABASE'."
--
This looks like data corruption. Run DBCC CHECKDB on the database and see
how you go. If CHECKDB won't fix corruption, restore from your latest good
backup.
Hope this helps,
--
Eric Cárdenas
SQL Server support|||Hi Don
You've asked this in two separate newsgroups and started two threads of
answers.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"I_AM_DON_AND_YOU" <anonymous@.discussions.microsoft.com> wrote in message
news:1467a01c3c349$12455b30$a601280a@.phx.gbl...
> WHen I run a simple query against a table I get the
> following error:
> Could not find the index entry for
> RID '163939393034313038342020202020205041313130332020202020
> 203030333431332020202036000500' in index page (1:65918),
> index ID 0, database 'MYDATABASE'."
>
> What's the reason?
>