Yes and no. In one case, I found concurrent queries and I also found 2 sessions hitting the same table. >Did you find any concurrent queries?
>For a deadlock you need at least two SQL sessions hitting the same object. > > > >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' The strange thing is also, the second case, which was when we got the error, on a different day, on a different table, but we couldn't find 2 sessions that hit the table at the same time. The query is similar, but the tablename is different and there are a lot more columns being updated. Thanks for responding, Ali ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
