SET DEADLOCK_PRIORITY (T-SQL)

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 1204 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.

See Also