title: MSSQL: Disable triggers for one INSERT
body: <p>This question is very similar to <a href="https://stackoverflow.com/questions/123558/sql-server-2005-t-sql-to-temporarily-disable-a-trigger">SQL Server 2005: T-SQL to temporarily disable a trigger</a></p>
  
  <p>However I do not want to disable all triggers and not even for a batch of commands, but just for one single INSERT.</p>
  
  <p>I have to deal with a shop system where the original author put some application logic into a trigger (bad idea!). That application logic works fine as long as you don't try to insert data in another way than the original "administration frontend". My job is to write an "import from staging system" tool, so I have all data ready. When I try to insert it, the trigger overwrites the existing Product Code (not the IDENTITY numeric ID!) with a generated one. To generate the Code it uses the autogenerated ID of an insert to another table, so that I can't even work with the @@IDENTITY to find my just inserted column and UPDATE the inserted row with the actual Product Code.</p>
  
  <p>Any way that I can go to avoid extremly awkward code (INSERT some random characters into the product name and then try to find the row with the random characters to update it).</p>
  
  <p>So: Is there a way to disable triggers (even just one) for <strong>just one</strong> INSERT?</p>