Ben Mueller wrote: > Thanks, Jochem, for the reply. I glanced at that call just briefly; does it > clear *all* stored execution plans, or just a specified one? It seems like > the only way it would be useful in this context is if it cleared them all, > since we have no way of knowing which plans are cached.
I don't know, you might evenneed one of the other DBCC FREE..... commands. Try it :) > A larger question is this: isn't this a huge headache for everybody? We > update our site a lot--sometimes several times a day If by update you mean a schema change I think you are the exception rather then the rule. 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:296673 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4