title: How to prevent database trigger updating @@identity after Insert
body: <p>I am adding a trigger to an existing database table, which is used by an application I did not code, and cannot change the code in.</p>
  <p>I want to insert some information from <code>TableA</code> into <code>TableB</code> on <code>INSERT</code> into <code>TableA</code>.</p>
  <ol>
  <li>Application runs <code>INSERT INTO TableA</code> &lt;-- this updates <code>@@identity</code></li>
  <li>An <code>ON INSERT</code> trigger that runs on <code>TableA</code> then inserts data into <code>TableB</code> &lt;-- this also updates the <code>@@identity</code> with a new value</li>
  <li>Application reads <code>@@identity</code> &lt;-- which is from <code>TableB</code> not from <code>TableA</code> as the application is expecting</li>
  </ol>
  <p>Is there any way to <strong>not update</strong> the <code>@@identity</code> from within the trigger?</p>