title: SQL Server - table seems to be blocked
body: <p>I attempted to save a graph of objects using NHibernate. The save failed due to a not-null constraint violation.</p>
  
  <p>I am now finding that a table in the database corresponding to one of the objects in the graph now appears to be locked. I cannot query it. Whenever I try, it just sits there doing nothing until I cancel the query. This has been the case for about half an hour.</p>
  
  <p>In the save code, the transaction is first committed and then disposed.</p>
  
  <p>SELECT @@TRANCOUNT against the database gives 0.</p>
  
  <p>Any ideas a) What's going on and b) How can I get the table back?</p>