I have an issue with an index on a Sql2k server:
Event Log shows the following errors happening:
Date 2/14/2012 9:54:19 AM Log SQL Server (Current - 2/14/2012 10:26:00 AM) Source spid111 Message Error: 644, Severity: 21, State: 5
and then ...
Date 2/14/2012 9:54:19 AM Log SQL Server (Current - 2/14/2012 10:26:00 AM) Source spid111 Message Could not find the index entry for RID '16958f0b001e00020000' in index page (4:964157), index ID 74, database 'db'..
I've been chasing this error and have already ruled out http://support.microsoft.com/kb/822747
Then I found the following forum discussion:
My question, I guess, is whether or not anyone knows this "undocumented way to turn on dumping for a particular error." (last forum entry).
Thank you, in advance.