Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim

Error message:

Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

But if I don’t want this process to be the deadlock victim?

Solution:

SET DEADLOCK_PRIORITY HIGH

see here:

http://copypastenet.blogspot.co.il/2014/01/set-deadlockpriority.html