title: When do triggers fire and when don't they
body: <p>Pretty general question regarding triggers in SQL server 2005.</p>
  
  <p>In what situations are table triggers fired and what situations aren't they?</p>
  
  <p>Any code examples to demonstrate would be great.</p>
  
  <p>I'm writing a audit based databases and just want to be aware of any situations that might not fire off the triggers that I have set up for update, delete and insert on my tables.</p>
  
  <p>A example of what I mean,</p>
  
  <pre><code>UPDATE MyTable SET name = 'test rows' WHERE id in (1, 2, 3);
  </code></pre>
  
  <p>The following statement only fires the update trigger once.</p>