Ali Awan wrote: > > In one case, I found concurrent queries and I also found 2 sessions hitting > the same table.
If the concurrent queries do not lock the records in the same order as the transaction does, that can cause deadlocks. >> It is not unlikely this can deadlock, but to be certain we need to see >> the actual SQL. > This is the SQL > Update DMSdata Set PolicyNumber = '345627' where ID = '94631' According to your description, the transaction did an update and a delete, not just a delete. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277466 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
