December 4, 2007 at 9:31 am
Hi,
We have compiled a stored procedure which typically encapsulate a few UNION statements and outputs into XML (using XML Explicit). The query is a bit on complicated side. The same was working perfectly but from today morning it's throwing the following error
'Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information'
Strangely this error only occurs when called from the application, it's runs perfectly from the query analyzer.
Any help will be greatly appreciated. It is quite urgent
December 4, 2007 at 3:56 pm
Shot in the dark, but if the query analyzer has updated stats... ?
sp_MSForEachTable "UPDATE STATISTICS ? with fullscan"
Warning.... update stats can take a bit of time...
Daryl
December 5, 2007 at 1:02 am
Thank you so much Smith, I doubt if the statistics are updated. We wil try this option and get back.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply