Monthly Archives: November 2007

Negative Process ID (spid -2) in SQL Server

Posted on November 18, 2007 by robkraftmsn

I didn’t know negative spids existed until I found one blocking other processes on my SQL Server 2005 box.  The source of the negative spid (SQL Server Process ID), specifically a spid of -2, was the Microsoft Distributed Transaction Coordinator … Continue reading →

Posted in SQL Server | 24 Comments