By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

Internal query processor error

P: n/a
Hi,

I am trying to execute rather complex query, and I got query processor
error. I read the Microsoft support page and it said I should install SP4,
and I did, but the error is still there.

I am running MSDE with SP4 installed. Everything else works like a charm.

Zvonko
Mar 31 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Zvonko Bičkup (zb*****@gmail.com) writes:
I am trying to execute rather complex query, and I got query processor
error. I read the Microsoft support page and it said I should install SP4,
and I did, but the error is still there.
There are probably more than one way to achieve an internal query
processor error, so even if they fixed one issue or two in SP4, it does
not mean that they fixed them all.

Without seeing the query or the database, the only advice I can give is
to try to break up the query in pieces, possibly storing intermediate
results in a temp table.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Mar 31 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.