Jochem, I tried the DBCC FREEPROCCACHE routine after making a schema change - but it does not prevent the 'invalid data type" error that sometimes occurs. Any other useful routines you can think of?
-mark -----Original Message----- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 1:49 PM To: CF-Talk Subject: RE: cfqueryparam, cached execution plans, and changing table structure Jochem, So... If I ran the DBCC operation on the SQL server to flush the execution plan cache immediatley after a shema change - I would not have to fiddle with the queries or restarts or other techniques to draw it over to CF? If so - that's a great tip. -Mark -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 1:33 PM To: CF-Talk Subject: Re: cfqueryparam, cached execution plans, and changing table structure Ben Mueller wrote: > It sounds like the only time this is a problem is under the following circumstance: alterations to an existing DB table where a related execution plan is stored in memory. Correct. > I'm mostly annoyed that this doesn't "just work". Maybe that's unrealistic of me, but I don't think it's unreasonable of me. It is a MS SQL Server issue. Oracle, PostgreSQL etc. do not have this problem, they flush their cache on schema changes. So I agree that it is not unrealistic to expect that it would be handled automatically. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4