title: SQL Server error on update command - "A severe error occurred on the current command"
body: <p>Running the following query in SQL Server Management Studio gives the error below.</p>
  
  <pre><code>update table_name set is_active = 0 where id  = 3
  </code></pre>
  
  <blockquote>
    <p>A severe error occurred on the current command.  The results, if any, should be discarded.</p>
  </blockquote>
  
  <ul>
  <li>The logs have been truncated</li>
  <li>there is an update trigger but this isnt the issue</li>
  <li>the transaction count is zero  (@@trancount)</li>
  </ul>
  
  <p>I have tried the same update statement on a couple of other tables in the database and they  work fine.</p>
  
  <pre><code>DBCC CHECKTABLE('table_name');
  </code></pre>
  
  <p>gives</p>
  
  <pre><code>DBCC results for 'table_name'.
  There are 13 rows in 1 pages for object "table_name".
  DBCC execution completed. If DBCC printed error messages, contact your system administrator.
  </code></pre>