x

Need help to solve a deadlock

Hi All,

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

more ▼

asked Apr 18 at 06:27 PM in Default

avatar image

Abhishek
18 1 1 4

Can you post a picture of the deadlock graph?

Apr 18 at 07:22 PM JohnM

thanks for looking, I have attached the script and graph again

Apr 19 at 04:24 AM Abhishek
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x60

asked: Apr 18 at 06:27 PM

Seen: 47 times

Last Updated: Apr 19 at 04:24 AM

Copyright 2016 Redgate Software. Privacy Policy