How to kill SPID -2?

A negative SPID (-2) is because of an orphaned distributed transaction.
Please follow below steps to kill it:

Step 1: -- Find the UOW Number
select req_transactionUOW
from master..syslockinfo
where req_spid = [SPID Number. It is -2 here]

Step 2: -- Copy the UOW number from Step one
KILL ‘[UOW Number you found for Step 1]’

This will kill SPID -2 (Negative SPID). For a more detailed discussion on this issue, please visit