Dana, Not pretty...and often not possible. Consider the many many sites on shared hosts. How do they handle this situation?
-mark -----Original Message----- From: Dana Kowalski [mailto:[EMAIL PROTECTED] Sent: Friday, January 18, 2008 8:24 AM To: CF-Talk Subject: Re: cfqueryparam, cached execution plans, and changing table structure well one simple solution is to only do updates during a scheduled maintenance period daily. During that time you have the services bounce for CF and SQL. Its not pretty but its effective. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:296818 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4