Post reply

Internal Query Processor Error

  • September 26, 2003 at 8:02 am

    #160154

    We use a large query in one of our stored procedures. Recently we had to add a few more fields to the query and now I am not able to execute the query. I am receiving this message in QA:

    Server: Msg 8621, Level 17, State 1, Line 145

    Internal Query Processor Error: The query processor ran out of stack space during query optimization.

    Is there a way to modify the SQL Server's stack space, instead of modifying the query or using a temp table?

    Thanks.

    Andrew J. Hahn


    Andrew J. Hahn

  • September 26, 2003 at 3:27 pm

    #476084

    No, I am afraid not. The Stack space is not one of the configurable options.

    In any case, if this is a huge IN statement (for example), then using an external source (e.g. a temp table) with a JOIN will be significantly fasyer.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply