Posted by Alex Kuznetsov on 08/17/07 13:52

On Jul 30, 3:17 am, steven <sfuc...@verizon.net> wrote:
> 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

Steve,

the following article will be useful:

http://www.devx.com/CoDe%20Magazine/Article/17447/0/page/7

Alex Kuznetsov, SQL Server MVP
http://sqlserver-tips.blogspot.com/

[Back to original message]