Mark Kruger wrote: > 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?
No, but I just realized where there is an error in my logic. I was assuming that once you flush the execution plan cache it would solve the problem. But that is only true if automatic recompilation is supported. 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:296701 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
