title: Merge statement and after triggers on target table
body: <p>I have two after triggers on target table (one for insert and one for update).
  Now if I execute merge on the target table, the triggers are executed only once. Although the merge statement executes around 300 updates, and 200 inserts.</p>
  
  <p>I checked it with print statements in each trigger, right after getting data from deleted, inserted record into variables.</p>
  
  <p>How come? Is this a bug?</p>
  
  <p>I have SQL Server 2008 sp1 std (part of the SBS2k8). </p>