December 5, 2003 at 10:22 am
Hi All,
Does anyone know how to cure the following:
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:143) with latch type SH. sysindexes failed.
And I received this message after running 'DBCC CHECKDB', in response to a user whose original problem was this message from a query;
Server: Msg 7105, Level 22, State 6, Line 1
Page (1:67874), slot 5 for text, ntext, or image node does not exist.
Connection Broken
We are running Sql 2000 with patch Sp3a as this was recommended to fix the above user error, although it appears to not have done this !.
If the user issues the query without a 'group by' or 'order by' statement then it works, but slap in 'order by' or 'group by' & it fails !?!?!
So any ideas as I'm stumped ( after following to the letter Microsofts solution to this problem ! ).
Yet another SqlServer 'feature'!!, ah well it keeps me busy.
Thanks in advance for anyone brave enough to answer this tricky problem.
Regards.
j
December 8, 2003 at 8:00 am
This was removed by the editor as SPAM
December 8, 2003 at 11:44 am
Have you run a dbcc checkdb? I'd be curious to see if this shows up there. The latch issue might be fixed with a clustered reindex rebuild of the tables involved. The text/image item is more worrisome. If you cannot read all the rows of the tables, including the image data, I'd call PSS and they may be able to help you track down the image data pages that are missing and extract them.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply