June 28, 2004 at 7:31 am
I've resored but keep getting the following error 'index ID 0. Chain linkage mismatch. (4:1044477)->next = (4:1029568), but (4:1029568)->prev = (4:1029567). [SQLSTATE HY000] (Error 8908).' when I run.
Any idea how I resolve this?
June 28, 2004 at 8:04 am
Check KB articles:
http://support.microsoft.com/default.aspx?scid=kb;en-us;308886&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;811205&Product=sql2k
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
June 28, 2004 at 8:56 am
Related to link one we are not using NOLOCk in the stored procedure.
Related to link 2 we are on service pack 3.
Any other ideas?
June 28, 2004 at 9:14 am
Do you have a spare/different SQL server? Try restoring the DB on that server. See if it looks okay. Then detach the database on server B and reattach on Server A.
The note in article says the hotfix should be free from M$. If you call on it, make sure you don't give them a credit card number. They will try to charge you.
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply