<div>
Have you tried looking in the sysobjects table of the relevant database?
</div>


Have you tried looking in the sysobjects table of the relevant database?

<div>
Many thanks that worked I have the index name and table now.<br />
<br />
If I drop the index and recreate it would this fix the error?<br />
<br />
Regards<br />
Mike
</div>


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

<div>
Many thanks<br />
<br />
Regards
</div>


<div>
<div class="content wysiwyg-content">
I have got the following error on SQL server 2000 SP 3a<br />
<br />
<br />
Event Type: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Error<br />
Event Source: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MSSQLSERVER<br />
Event Category: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(2)<br />
Event ID: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;17052<br />
Date: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15/Nov/2006<br />
Time: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11:11:58<br />
User: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;N/A<br />
Computer: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ZAJHBMUR-SQL01<br />
Description:<br />
Error: 8908, Severity: 22, State: 6<br />
Table error: Database ID 7, object ID 73207461, index ID 6. Chain linkage mismatch. (3:1015910)-&gt;next = (3:1015911), but (3:1015911)-&gt;prev = (3:2659497).<br />
<br />
I know which database it refers to but how can I find out which table it refers?<br />
<br />
SQL server log shows the same reference.<br />
<br />
I did dbcc checkdb which returned no errors.<br />
<br />
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.<br />
<br />
Please advise<br />
Mike Ward
</div>
</div>


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

Chain Linkage mismatch error 8908

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.