SET DEADLOCK_PRIORITY
Controls the way the session reacts when in a deadlock situation. Deadlock situations arise when two processes have data locked, and each process cannot release its lock until other processes have released theirs.
Syntax
SET DEADLOCK_PRIORITY { LOW | NORMAL | @deadlock_var }
Arguments
LOW
Specifies that the current session is the preferred deadlock victim. The deadlock victim's transaction is automatically rolled back by Microsoft® SQL Server™, and the deadlock error message 1205 is returned to the client application.
NORMAL
Specifies that the session return to the default deadlock-handling method.
@deadlock_var
Is a character variable specifying the deadlock-handling method. @deadlock_var is 3 if LOW is specified, and 6 if NORMAL is specified.
Remarks
The setting of SET DEADLOCK_PRIORITY is set at execute or run time and not at parse time.
Permissions
SET DEADLOCK_PRIORITY permissions default to all users.