Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-09 : 08:27:13
|
| Muthiah writes "I am getting following error, while executing/running the in SQL Query Analyzer. Same was working fine since last six months... --quote---Server: Msg 8623, Level 16, State 1, Procedure WP_StockOpVer5, Line 889Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information.--quote---Any soultion for this..?RgdsMuthiah" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-09-09 : 08:29:20
|
| This error usually occurs with very complicated queries, often with subqueries (especially multiple-nested subqueries) Although it used to work earlier, it's likely the data, indexes, and statistics have changed in some way that the query optimizer can no longer create a workable plan. The only way to truly fix the problem is to rewrite the code to something less complex. |
 |
|
|
n/a
deleted
35 Posts |
|
|
|
|
|
Getting following Error - While executing the a SP