SQL error manifests itself after running sucessfully before.

• Mark Kinnear

  SSC Eights!

  Points: 850

  More actions

  May 13, 2010 at 12:55 am

  #94902

  Hi guys, ive been working with a simple update statement which ran sucessfully, but then began thowing an error each time executed. Msg 8624, Level 16, State 116, Line 1

  Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services. After reading up on it at http://support.microsoft.com/kb/931329 it claims to be a bug. What doesnt make sense is that it ran perfectly before, something else may be happening here. The query im running isUPDATE

  I

  SET

  DropTrans = 1

  FROM

  ImportPrep I (NOLOCK)

  JOIN UniverseWarehouse_TFC.dbo.[Transaction] Tr (NOLOCK) ON Tr.AccountId = I.AccountID

  WHERE

  (DATEDIFF(dd, I.TransactionDate, Tr.TransactionDate) = 0) AND

  I.DtCode = Tr.DTCode AND

  I.Details = Tr.Details

  The ImportPrep table was a temp table which i changed to physical one, simply to see if that had any sort of impact, but the issue remains. I cant believe that this sort of error would happen out of the blue when it was running perfectly before. SQL version im running on is: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

  Thanx in advance.

• dmoldovan

  SSCertifiable

  Points: 6334

  More actions

  May 13, 2010 at 4:02 am

  #1166745

  See if this helps

  http://support.microsoft.com/kb/951574

• Atif-ullah Sheikh

  SSChampion

  Points: 12495

  More actions

  May 17, 2010 at 12:43 am

  #1168118

  I found something here...

  http://support.microsoft.com/kb/931329

  Best of Luck...

  ----------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Sometimes, winning is not an issue but trying.

  You can check my BLOG [font="Arial Black"]here[/font][/url][/right]