I am trying to understand the reason for this deadlock and how can I avoid it. Attached is the query to create schema and run script to generate deadlock.
I am getting the deadlock on same table and on PK.
Thanks Abhishek link text
Apr 18 at 06:27 PM
Apr 19 at 04:23 AM
Can you post a picture of the deadlock graph?
thanks for looking, I have attached the script and graph again
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Apr 18 at 06:27 PM
Seen: 47 times
Last Updated: Apr 19 at 04:24 AM
What am I doing wrong, to detect deadlocks?
Deadlock Problem With UPDATE
Take long time to drop a view
Issue with Deadlock
how to overcome deadlock when generating unique IDs
How to resolve this deadlock error
Dead lock due to stored procedure and trigger accessing same table in SQL server 2008
DeadLock and Transactions
TIP: How to read a deadlock graph?