SET Deadlock_priority - sets the importance of the current session if it is deadlocked with another session.

SET Deadlock_priority Syntax:

SET DEADLOCK_PRIORITY { LOW | NORMAL | HIGH | <numeric-priority> | @deadlock_variable } ;
<numeric-priority> ::= { -10 | -9 | ... | 0 | ... | 9 | 10 }

SET Deadlock_priority Example:

SET DEADLOCK_PRIORITY NORMAL;
GO