title: BlockingSPID is 0 - SQL Server 2005
body: <p>What does it mean when all BlockingSPIDs are 0?
  I'm trying to troubleshoot deadlocks with this <a href="http://www.techrepublic.com/blog/datacenter/find-blocking-processes-using-recursion-in-sql-server-2005/275" rel="nofollow noreferrer">article</a> but not getting any results.</p>
  
  <p>Thank you.</p>
  
  <p>The errors I'm getting look like this:</p>
  
  <p><img src="https://i.stack.imgur.com/N5HY1.png" alt="enter image description here"></p>