Internal query processor error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zvonko Bi¹kup - 31 Mar 2008 06:41 GMT

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

Reply to this Message

Erland Sommarskog - 31 Mar 2008 22:16 GMT

> 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.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message