question

MN17 avatar image
MN17 asked

Error: 7102 Severity 20 State 99 SQL 2K5 SP3

Hi, I have recieved the above error on a SQL2K5 SP3 server. SQl was restarted on the server as it had stopped processing queries. The error appeared once before and once after the restart. there have bee subsequent consistency checks ran on the databases on the server with no errors reported. I have found lots of articles relating to SQL 7/2K and this error but nothing on SQL 2005. Has anyone seen this before or have any advice? Kind Regards M
sql-server-2005error-message
7 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Please see this [KB][1]. See especially the resolution part. Hope it helps. Moreover, Are you with latest SP3 CUs? Infact, you should have been with SP4 by now, in case if you have no other alternative but to seek help from Microsoft CSS. Please keep updating this post as it could get you much better help or may help someone to follow. Thanks. [1]: http://support.microsoft.com/kb/974205
1 Like 1 ·
I found this for SQL 2008 & R2... - advice seems to be to run DBCC CheckTable.
0 Likes 0 ·
Hi - Sorry I should have also said that this was immediately after the 1st msg - Internal Error: Text manager cannot continue with current statement. Run DBCC CHECKTABLE. A later checkdb was run on all of the databases on the server and no errors were reported.
0 Likes 0 ·
Have you checked the error log for error message 1204?
0 Likes 0 ·
There are no 1204 error messages in the log.
0 Likes 0 ·
Show more comments

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.