Post reply

Msg 8623, Sev 16: Internal Query Processor Error

  • December 12, 2005 at 12:03 am

    #152658

    Hi all,

    I am getting the following error while running an SP

    my server is SQL Server 2000 Standard edition (8.00.250) with SP3

    Msg 8623, Sev 16: Internal Query Processor Error: The query processor could not produce a

    query plan.  Contact your primary support provider for more information. [SQLSTATE 42000]

    As per MS KBase, i need to apply the latest service pack. But i have SP3 installed on my box.

    any idea on this ?

     

     


    subban

  • December 12, 2005 at 12:52 am

    #608944

    The 8.00.250 is 2000 No SP+Q291683.  That means you are running without ANY SQL Server service packs.  You need to patch badly.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • December 12, 2005 at 1:45 am

    #608948

    sorry it is 8.00.850 with SP3


    subban

  • December 13, 2005 at 10:33 am

    #609263

    Latest Service Pack release is SP4.

  • December 15, 2005 at 3:58 pm

    #609918

    Could you post the source of the SP ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • December 16, 2005 at 8:19 am

    #610077

    http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

  • July 9, 2007 at 2:41 pm

    #718105

    Hello, I am having the same problem but I appear to be running SP4 already for SQL Server 2000.   Any ideas?  Here is what I am running against SQL Server:

    SELECT @@VERSION

    GO 

    My Results:

    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)

     May  3 2005 23:18:38

     Copyright (c) 1988-2003 Microsoft Corporation

     Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Viewing 7 posts - 1 through 6 (of 6 total)

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