Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    10

    Unanswered: SQL Server 2005 Error 8630: Internal Query Processor Error

    I have a SProc that runs across many clients without any problems. Every now and then, though, I get the following error:

    Internal Query Processor Error: The query processor encountered an unexpected error during execution. [SQLSTATE 42000] (Error 8630).

    All I am doing is populating Temp tables with some data and then joining them together to create a Global Temp table that is being BCP'd to a network share.

    Has anyone come across this error in SQL Server 2005? I cannot find anything on Google or Microcsoft.

    Thanks,
    Robert

  2. #2
    Join Date
    Mar 2005
    Location
    Netherlands
    Posts
    280
    I've come accross this error in SQL 2000, it sometimes happens when it's querying tables with more than 256 columns and has to process the columns (eg. with a function of some sort).

    Hope this helps.

Posting Permissions

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