title: TSQL - Disabling Triggers in Transactions
body: <p>I've search high and low, and I haven't been able to find a satisfactory answer to my question. Which tends to boil down to how exactly a <code>TRANSACTION</code> works in SQL Server.</p>
  
  <p>Basically, will this do what I think it does.</p>
  
  <pre><code>BEGIN TRAN
  
  DISABLE [my_update_trigger] ON [my_table]
  
  /*.. Do Some Updates ..*/
  
  ENABLE [my_update_trigger] ON [my_table]
  
  COMMIT TRAN
  </code></pre>
  
  <p>I want to be able to fix some data in a table, without running the update triggers 
  I have on the table. This is for a web app, so I'd like to make sure that if an update is done on the table from the web app, while I'm doing my work, <code>[my_update_trigger]</code> will still fire for the web app.</p>