Chain Linkage mismatch error 8908

I have got the following error on SQL server 2000 SP 3a


Event Type:      Error
Event Source:      MSSQLSERVER
Event Category:      (2)
Event ID:      17052
Date:            15/Nov/2006
Time:            11:11:58
User:            N/A
Computer:      ZAJHBMUR-SQL01
Description:
Error: 8908, Severity: 22, State: 6
Table error: Database ID 7, object ID 73207461, index ID 6. Chain linkage mismatch. (3:1015910)->next = (3:1015911), but (3:1015911)->prev = (3:2659497).

I know which database it refers to but how can I find out which table it refers?

SQL server log shows the same reference.

I did dbcc checkdb which returned no errors.

It appears to be an index that is involved in which case I have read that a dbcc checktable repair_rebuild may fix the error. However I don't know which table to run it on.

Please advise
Mike Ward
MURSHIPAsked:
Who is Participating?
 
wtapsellConnect With a Mentor Commented:
For the relevant table:

select      *
from      sysobjects
where      id = 73207461


For the relevant index:

select      *
from      sysindexes
where      id = 73207461
and            indid = 6
0
 
wtapsellCommented:
select
0
 
wtapsellCommented:
Have you tried looking in the sysobjects table of the relevant database?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
MURSHIPAuthor Commented:
Many thanks that worked I have the index name and table now.

If I drop the index and recreate it would this fix the error?

Regards
Mike
0
 
wtapsellCommented:

That should work.
0
 
MURSHIPAuthor Commented:
Many thanks

Regards
0
All Courses

From novice to tech pro — start learning today.