title: Sql server table can be queried but not updated
body: <p>i have a table which was always updatable before, but then suddenly i can no longer update the any of the columns in the table.  i can still query the whole table and the results come back very fast, but the moment i try to update a column in the table, the update query simply stalls and does nothing.</p>
  
  <p>i tried using </p>
  
  <pre><code>select req_transactionUOW
  from master..syslockinfo
  where req_spid = -2
  </code></pre>
  
  <p>to see if some orphaned transaction was locking the table, but it returns no results.</p>
  
  <p>i can't seems to find signs of my table being locked, but simply cannot update it.  any clues as to how to fix the table or whatever state it is in?</p>