Internal query processor error

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Zvonko Bi¹kup
    #1

    Internal query processor error

    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


    Tags: None
    • Erland Sommarskog
      #2
      Re: Internal query processor error

      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@sommarsk og.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

        Comment

        Previous template Next
        Working...