title: What is blocking my query?
body: <p>I have a very interesting situation in SqlServer: I cannot find the process blocking another process.
  I run the following select:</p>
  
  <pre><code>SELECT * FROM sys.sysprocesses WHERE blocked &gt; 0
  </code></pre>
  
  <p>There I receive a single row containing the value "58" in blocked.
  Thus I send the following statement:</p>
  
  <pre><code>SELECT * FROM sys.sysprocesses WHERE spid = 58
  </code></pre>
  
  <p>And I get nothing!
  How is this possible?</p>
  
  <p>I am using Sqlserver 2008 R2</p>