jitendra.padhiyar (1/15/2013)

---

The were trying to perform below delete operation:

DELETE FROM PTPortalUser.PTJOBLOGS WHERE INSTANCEID < 614469

and got error message:

Msg 8908, Level 22, State 6, Line 1

Table error: Database ID 23, object ID 901578250, index ID 0. Chain linkage mismatch. (1:753306)->next = (1:753307), but (1:753307)->prev = (1:706408).

It seems its consistency error that Checkdb was not able to repair. Should I run checkdb again with All_ErrorMSGS ? to know whts going on ? OR any other way to cope with this error ? Indexid=0 seems cluster index issue..

Now, please run this so I can see if there are any remaining errors

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS