title: How to see SQL 2008 Locks and Blocked Tables
body: <p>During the ASP.NET execution of my app, it seems SQL 2008 Express holds some lock, and I get</p>
  
  <blockquote>
  <pre><code>Timeout expired.  The timeout period elapsed prior to completion of
  </code></pre>
    
    <p>the operation or the server is not
    responding</p>
  </blockquote>
  
  <p>Maybe some of my query is not optimized. Visual Studio crashes with:</p>
  
  <blockquote>
  <pre><code>Microsoft Visual Studio may be unstable now. It is recommended that
  </code></pre>
    
    <p>you save all files and exit.</p>
  </blockquote>
  
  <p>I need to see what query is blocking my tables, but I have the Express version. How can I do?</p>
  
  <p>Thanks</p>