SQL Server – Resolving SQL Blocking with SPID of -2

sql server

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

enter image description here

Best Answer

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