DEADLOCK VOLUNTEER V2K

Everyone hates the dreaded deadlock scenario. Deadlock is when two
processes have "locked" data, and each process cannot release its lock 
until
other process has released its. And when SQL Server encounters 
deadlock,
it decides to kill one of the two processes holding the resources.

You can affect the decision that SQL Server makes by setting a deadlock
priority on your process.

There are two options for deadlock priority: LOW and NORMAL. Most
processes occur at the NORMAL level. If you are issuing a transaction 
against a
batch process that takes a long time to execute, consider volunteering
your process as the deadlock victim. By setting the DEADLOCK_PRIORITY
option to LOW, you can volunteer your process as the one to be killed 
if it
should cause a deadlock.

To do so, type the following in the query window isql/w:

SET DEADLOCK_PRIORITY LOW | NORMAL

Note that DEADLOCK_PRIORITY is set at execute or run time and not at
parse time.

----------------------------------------