title: SQL Server 2005: T-SQL to temporarily disable a trigger
body: <p>Is it possible to disable a trigger for a batch of commands and then enable it when the batch is done?</p>
  
  <p>I'm sure I could drop the trigger and re-add it but I was wondering if there was another way.</p>