SQL Blocking, SPID of -2 We have some blocking going on in our database and when I run sp_who2, in the BlkBy field, I see "-2" for two of the rows.  What does this mean?  Running SQL Server 2008 R2
I see "-2" for two of the rows. What does this mean?


It means you have an open DTC transaction managed by an external ITransaction interface but no Sessions currently using it.

you have to use KILL UOW where UOW = UnitOfWork associated with that transaction instead of the session id.

---- in text mode run below query 

select 'kill ' , req_transactionUOW
from master..syslockinfo
where req_spid = -2