INF: Specifying Priority for Deadlock Victim Selection

View products that this article applies to.

This article was previously published under Q58534

Expand all | Collapse all

SUMMARY

In Microsoft SQL Server version 4.2x, when a deadlock condition occurs between two user-defined transactions, the transaction that has used more resources is allowed to continue and the other is rolled back.

In Microsoft SQL Server version 6.0, you can prioritize deadlock settings by using the SET DEADLOCK_PRIORITY statment. For more information on setting deadlock priority, see Microsoft SQL Server Books Online, "Transact- SQL Reference", the SET statement.