title: IDENTITY_INSERT in trigger
body: <p>Is it possible to turn it on in a table trigger? </p>
  
  <p>I tried creating a trigger with 
  SET IDENTITY_INSERT tableName ON</p>
  
  <p>But when I open the trigger definition, I see that the statement is not there....</p>
  
  <p>This is my query to alter my trigger to add the IDENTITY_INSERT, when I open the definition, the IDENTITY_INSERT is removed ...</p>
  
  <pre><code>SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  SET IDENTITY_INSERT dbo.MyTable ON
  GO
  
  ALTER TRIGGER [dbo].[MyTrigger]
  ON [dbo].[MyTable]
  AFTER INSERT AS
  
  
  
  INSERT INTO MyOtherTable
  (   
      // values
  )
  
  
  SET IDENTITY_INSERT dbo.MyTable OFF
  </code></pre>