I am getting this error on my Database

Could not find the index entry for RID
'36a591e90000fcffff03000001001300475448' in index page (1:6334042), index ID
2, database 'refdb'.

How can I find the corrupt table from the above information?

Thanks in Advance!!!

It depends... You dont just want to find the table, you want to fix the
issue too.

Are your symptoms the same as this?
http://support.microsoft.com/kb/822747

If so - follow the instructions from MS.


<msnews.microsoft.com> wrote in message
news:%23jU6Xd1WHHA.2212@TK2MSFTNGP02.phx.gbl...
>I am getting this error on my Database
>
> Could not find the index entry for RID
> '36a591e90000fcffff03000001001300475448' in index page (1:6334042), index
> ID 2, database 'refdb'.
>
> How can I find the corrupt table from the above information?
>
> Thanks in Advance!!!
>
>

I Know that, I was asking if I can find out the Table name that has the
issue from the info provided by SQL error log without running DBCC CHECKDB

"Immy" <therealasianbabe@hotmail.com> wrote in message
news:OxgG%23o1WHHA.4880@TK2MSFTNGP05.phx.gbl...
> It depends... You dont just want to find the table, you want to fix the
> issue too.
>
> Are your symptoms the same as this?
> http://support.microsoft.com/kb/822747
>
> If so - follow the instructions from MS.
>
>
> <msnews.microsoft.com> wrote in message
> news:%23jU6Xd1WHHA.2212@TK2MSFTNGP02.phx.gbl...
>>I am getting this error on my Database
>>
>> Could not find the index entry for RID
>> '36a591e90000fcffff03000001001300475448' in index page (1:6334042), index
>> ID 2, database 'refdb'.
>>
>> How can I find the corrupt table from the above information?
>>
>> Thanks in Advance!!!
>>
>>
>
>

If you execute dbcc page, the header information for the
page has a value for m_objid which is the object id the page
belongs to -
dbcc traceon(3604)
dbcc page(YourDB, YourFileNumber, YourPageNumber)

-Sue

On Wed, 28 Feb 2007 09:53:40 -0800, <msnews.microsoft.com>
wrote:

>I Know that, I was asking if I can find out the Table name that has the
>issue from the info provided by SQL error log without running DBCC CHECKDB
>
>"Immy" <therealasianbabe@hotmail.com> wrote in message
>news:OxgG%23o1WHHA.4880@TK2MSFTNGP05.phx.gbl...
>> It depends... You dont just want to find the table, you want to fix the
>> issue too.
>>
>> Are your symptoms the same as this?
>> http://support.microsoft.com/kb/822747
>>
>> If so - follow the instructions from MS.
>>
>>
>> <msnews.microsoft.com> wrote in message
>> news:%23jU6Xd1WHHA.2212@TK2MSFTNGP02.phx.gbl...
>>>I am getting this error on my Database
>>>
>>> Could not find the index entry for RID
>>> '36a591e90000fcffff03000001001300475448' in index page (1:6334042), index
>>> ID 2, database 'refdb'.
>>>
>>> How can I find the corrupt table from the above information?
>>>
>>> Thanks in Advance!!!
>>>
>>>
>>
>>
>

Hi

The page number is here: (1:6334042)
This indicates file 1, page 6334042 in the database indicated (refdb)

You can use the semi-documented DBCC PAGE command to find out what object
that page belongs to.
(It is 'semi' because it is described in KB articles, but not in the Books
Online. It's also described in great detail in the Inside SQL Server books.
;-) )

You need to enable traceflag 3604 to see the output from DBCC PAGE:

DBCC TRACEON(3604)
DBCC PAGE(refdb, 1, 6334042, 0)

The above will give you the page header, which should include a line like
this:

Metadata: ObjectId = 2137058649
Your actual value of course will be different. Make sure you are in the
right database, and then you can access the object name, substituting your
object ID from the one shown:

SELECT object_name(2137058649)
This will tell you the object name.

You did not tell us what version you are using, which should always be the
first thing you tell us for any problem report. However, all of the above
works for all versions after SQL Server 7, except that the output of DBCC
PAGE looks different, but you can still find the objectID.

If you are running SQL Server 2005, Service Pack 2, you don't have to be in
the refdb database. You can do the following:

select object_name(2137058649, db_id('refdb'))

--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com


<msnews.microsoft.com> wrote in message
news:%23jU6Xd1WHHA.2212@TK2MSFTNGP02.phx.gbl...
>I am getting this error on my Database
>
> Could not find the index entry for RID
> '36a591e90000fcffff03000001001300475448' in index page (1:6334042), index
> ID 2, database 'refdb'.
>
> How can I find the corrupt table from the above information?
>
> Thanks in Advance!!!
>
>