sql server error 7102: text manager cannot continue with current statement


I run a query on SQL Server (in Query Analyzer, let's say) and I receive the following error:

Server: Msg 7102, Level 20, State 99, Line 1
SQL Server Internal Error. Text manager cannot continue with current statement.

The only thing I can find over Internet is that this is a SQL Server bug that is supposed to be fixed with the Service Pack #2, which is installed on our server.

Here is my query:

select no_news, en_title_news, en_text_image_news, en_text_news
from news
where parsed_en = 0

The error has something to do with the text fields (en_text_image_news and en_text_news).
If I remove the en_text_image_news from the query, it executes well, but if I remove the en_text_news field, the error still fires.

I haven't found anything useful on the net and this problem has to be solved quickly cuz deadlines are coming real fast.


I will supply any further information you need, just ask!
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
Did you also install the SP2 on your client?
jeffrocksAuthor Commented:
Yes, I have it installed. I think it might have something to do with indexes too, cuz I've found errors in the index on this field, but again, I'm not sure...
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.
No comment has been added to this question in more than 245 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
   Accept: angelIII http:#8087241

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

EE Cleanup Volunteer
All Courses

From novice to tech pro — start learning today.