Database Reference
In-Depth Information
Figure 19-9.
Deadlock due to the multiple updates of the same row, Step 2
Finally, if in the trigger Session 1 tries to update the same row again, modifying the column that exists in
non-clustered index, it would be blocked by the Session 2, which held the shared (S) lock on the non-clustered
index row. Figure
19-10
illustrates this situation.
Figure 19-10.
Deadlock due to the multiple updates of the same row