> affected queries in our rather sprawling legacy application > (getting less sprawled by the day)
I hear you. For a legacy application, it is probably not worth the trouble to make all those changes. You may also want to check for multiple queries with @@IDENTITY and SCOPE_IDENTITY(). I remember seeing very different (and sometimes bizarre) results with CF8 across the different drivers. -Leigh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330298 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4