|
|
|
#1 |
|
Messages: n/a
Hébergeur: |
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 |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
Zvonko Bi¹kup (zbiskup@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, esquel@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 |
|
![]() |
| Outils de la discussion | |
|
|