Use transactions and better the DB design (which is easier said than done!).
Have you tied it down to one particular SQL Block? Maybe a report or an SP running a cursor? N -----Original Message----- From: Ryan Duckworth [mailto:[EMAIL PROTECTED] Sent: 20 October 2004 17:02 To: CF-Talk Subject: SQL Deadlock Does anyone have any ideas on how to prevent/handle database deadlock? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 132) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. We get a message similar to the one above about once a week. My guess is that the deadlock occurred b/c the same row was attempting to be read and written to at the same time. Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4272 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182013 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
