Microsoft KB Archive/58534

= INF: Specifying Priority for Deadlock Victim Selection =

Article ID: 58534

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q58534



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, &quot;Transact- SQL Reference&quot;, the SET statement.

Additional query words: sql6 deadlock locking

Keywords: kbenv KB58534

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.