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

Hi!

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.

PLEASE HELP!!!

I will supply any further information you need, just ask!
jeffrocksAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
Did you also install the SP2 on your client?
0
 
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...
0
 
CleanupPingCommented:
jeffrocks:
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 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
monosodiumgCommented:
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.

monosodiumg
EE Cleanup Volunteer
0
All Courses

From novice to tech pro — start learning today.