Posted by steven on 07/30/07 08:17

I have a small database that I have been testing.
I get an error about a transaction deadlock.
The code is in stored procedures and I added transactions to the sp's
but the error happened again.

I wrapped the whole sp in just one transaction and I don't have any
index on the tables.

When I test just by running a program that sends 3 calls at a time it
will get a deadlocked transaction as I send 6 or 9 at a time.

I am not sure how it can have a deadlocked transaction after I used
transactions(begin and commit) in the sp's.

Steve

[Back to original message]