Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Argentina
    Posts
    26

    Unanswered: Info about Error 8623

    Hi,

    SQL Server returned me error 8623 "Internal Query Processor Error: The query processor could not produce a query plan." I've looked for info in the SQL books, but there's no info about this error. I would appreciate it a lot if somebody could tell me what this error means, how is it triggered, and if it's possible, how to avoid it.


    Thanks a lot,

    Federico

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Where are you doing this?

    What's the query?

    It's dynamic, isn't it...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    It would be better if you quote the query involved as per Brett's reply.
    This KBA1 and KBA2 refers about 863 error.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Feb 2004
    Location
    Argentina
    Posts
    26
    I can't reproduce this error. So I think it's sporadyc. Anyway I'll check my SELECT clauses to see if there's something similar to what Satya's link mention. Again, thanks a lot

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578

    Cool

    PROFILER may help you to track the process of query against database, just in case if you don't know.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •