I get occasional SQL deadlocks on an application. [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 65) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
I noticed that some of my CFQuery's in my CFC's I don't have a name because they are an update or delete SQL command and I don't care to see any results. Thus I don't use <cfset var queryname = ""> because the query does not have a name. Could not specifying a name on the CFQuery cause these deadlocks? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
