|
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
Navigation:
[Reply to this message]
|