On Wed, 7 Jan 2004, Tim McAuley wrote:
> Hi,
>
> I have a stored procedure that is causing deadlocks when called multiple
> times synchronously. The odd issue is that the deadlock seems to be
> happening on different threads waiting for locks on transactions. What
> exactly is this transaction lock?
My first guess would be waiting on row level locks. Are you doing
anything with FOR UPDATE or foreign keys?