Community

SQL session blocked by a negative SPID (-2)

(Shreyas R Gowda) A couple of times now I have faced this issue with my clients where SQL Server session is blocked by another session that has a negative SPID value. When we ran sp_who2 the SPID value that was blocking was (-2). When we tried to KILL the session we got an error that this is not a v

/membership]
Read More (Community content)