title: SQL Server triggers - order of execution
body: <p>Does anyone know how SQL Server determines the order triggers (of same type, i.e. before triggers) are executed.  And is there any way of changing this so that I can specify the order I want.  If not, why not.</p>
  
  <p>Thanks.</p>