I cam across a situation where SQL server threw error 8623 ..can't create query plan. I can describe the situation that created the
error message, but my real question is: should I ever be able to get to this situation, or does this have to be a bug ? Is this
something I should get in touch with PSS for?
Win2k AS - SP2 & rollup
SQL 2000 EE - SP 2
MS Cluster Services (active / passive)
Server: Msg 8623, Level 16, State 2, Line 8
Internal Query Processor Error: The query processor could not produce a query plan.
How I got here:
The bug feels similar to what's described in some of the articles about SQL 7 (Q264005, Q235401,Q214818). The situation is I'm
doing a cross database (same machine) updates with some insert into / select from's. Its a fairly complicated statement. But I can
trace the sitiation to an indexed view. When I try to do a cross database update to a table the indexed view relys on I get the
error. Its quite possible all the indexed view requirements were not set in the source database. It almost feels like the engine
wants to give me one of those "can update because numeric round about is set incorrectly" but the error just can't bubble up.