title: How to kill or rollback active transaction?
body: <p>How can I kill or rollback, uncommitted transaction?</p>
  
  <p>I am listing my active transactions with the following sql:</p>
  
  <pre><code>SELECT * FROM sys.dm_tran_session_transactions 
  </code></pre>
  
  <p>My result is:</p>
  
  <pre><code>session_id  transaction_id       transaction_descriptor enlist_count is_user_transaction is_local is_enlisted is_bound
  ----------------------------------------------------------------------------------------------------------------------
  54          117260               0x0100000036000000     0            1                   1        0           0
  </code></pre>
  
  <p>I dont want to kill the session (54)...</p>
  
  <p>Thanks all</p>