Issue 2 :- How can you kill negative SPID or ORPHANED DISTIBUTION TRANSACTION

If you want to kill negative SPID or orphaned distribution transaction then follow the below steps.


1. Find the negative SPID number.

2. For e.g. is SPID number is -2 then run the below T-SQL

use master
go
select req_transactionUOW from syslockinfo where req_spid = -2
go

3. You will get a hexadecimal value with the above syntax and then run the below command.

KILL 'FE4A57F2-28C5-44F9-8416-B08760DFE7E9'

By this process you will be able to kill negative SPID.