SQL Server 2008 R2 - SP2 - build 10.50.4033.0
I have a SP that generates the following error:
Msg 8624, Level 16, State 1, Procedure p_intex_update_custom_deals, Line 266
Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.
I extract and run the code from the SP, it executes fine.
The SP was originally created with 'SET QUOTED_IDENTIFIER OFF', dropping and recreating the SP with 'SET QUOTED_IDENTIFIER ON' fixed the issue.
Before dropping and re-creating the SP I ran CHECKDB, updated statistics and re-indexed various heavily accessed tables, tried running the SP 'WITH RECOMPILE' and cleared the cache. No red flags.
This SP has been running fine for years and is running fine on other SQL Servers of the same build without issue. Any ideas why this SP would all the sudden start having issues?
_____________________________________________________________________
- Nate
@nate_hughes