title: Asynchronous Triggers in SQL Server 2005/2008
body: <p>I have triggers that manipulate and insert a lot of data into a <strong>Change tracking</strong> table for audit purposes on every insert, update and delete. </p>
  
  <p>This trigger does its job very well, by using it we are able to log the desired oldvalues/newvalues as per the business requirements for every transaction.</p>
  
  <p>However in <em>some</em> cases where the source table has a lot columns, it can take up to 30 seconds for the transaction to complete which is unacceptable.</p>
  
  <p><em>Is there a way to make the trigger run asynchronously?</em> Any examples.</p>