title: Detect if Insert / update came from Another Trigger?
body: <p>I have <strong>table1</strong> which is being updated and inserted with data via <strong>sp's</strong>.</p>
  
  <p>the update is per Id of the row ( not bulk update) - I mean - <code>Single update</code>.</p>
  
  <p>This table has Trigger <strong>Tg1</strong> - which updates some fields in the same record that has been updated . ( after the record updated in the db - TG1 update some of her fields)</p>
  
  <pre><code>I DONT HAVE ACCESS to TG1 !.
  </code></pre>
  
  <p>This table has another trigger which ive build <strong>Tg2</strong>.
  which archive the original  inserted record via   <code>SELECT * FROM   DELETED ... and insert to table Archive...</code></p>
  
  <p>the problem is that <strong>Tg2</strong> catches <code>also</code> the events for <strong>TG1</strong> ! ( it inserting to the archive table 3 records insted of 1.</p>
  
  <p>Question : Is there anyway (in <strong>TG2</strong>) to know that the Action came from <strong>Tg1</strong> ? ( so i would be able to avoid those events - since i need only the events which came from my sp.)</p>
  
  <p>How can i solve that ? ( i dont have access to tg1...)</p>