SET DEADLOCK_PRIORITY

Transact-SQL Reference

Transact-SQL Reference

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.

See Also

@@LOCK_TIMEOUT

SET

SET LOCK_TIMEOUT