title: Disable trigger hangs?
body: <p>I need to do this from an ASP.NET web app:</p>
  
  <pre><code>Alter Table Contacts Disable Trigger All 
  -- Do some stuff
  Alter Table Contacts Enable Trigger All
  </code></pre>
  
  <p>In some situations the <code>Disable Trigger</code> statement hangs. Where should I start looking to figure out what's causing this? If I restart SQL server it goes back to behaving normally.</p>