I have a seemingly simple deadlock graph that contains 2 SP's. One SP is updating a table, while another SP (the victim) is selecting from it. The interesting thing about the graph is that the SP that contains the select (and only a select)
is shown to own an UPDATE lock on the table that SP2 wants to update. How is this possible?
View Complete Post