Hi all - I've just hit a nasty bug in SQL Server 2005 (I was surprised, because the testing we've done did not yield any up to now) Basically I have a specific table into which I would like to perform a single-row insert as insert into myTable values ( blah, blah, blah ) Run as ad-hoc SQL, this works with no problem, but within a stored proc it always fails with this message: "Server: Msg 8624, Level 16, State 116, Line x Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services." This, as you might imagine, turns a simple insert into a pretty ugly problem. So I applied this cumulative hotfix: http://support.microsoft.com/kb/918222/ hoping that item "531When you run a query or a stored procedure in SQL Server 2005, certain conditions can cause the SQL Server optimizer not to be able to produce an execution plan." was my issue. No dice. The problem still happens. I have temporarily (and with a great deal of unpleasant work) substituted an ad-hoc version of this specific function in my app, and that seems to have at least gotten it running. Anyone else hit this? Tips?