title: SQL Server 2008 change data capture vs triggers in audit trail
body: <p>We have audit trail implemented using triggers on our web application. Those triggers log field level updates. So, in a table, if you have 5 column values changed, we have 5 records in the audit trail one for each column with old value and the new value.</p>
  
  <p>Recently we have upgraded to SQL Server 2008. I have been thinking of using the new change data capture feature as it gives a very neat row level update with very less efforts and it's super-easy to implement. Just wanted to get some opinions from people who have been using change tracking for any caveat or any other real-world useful info on this.</p>
  
  <p>Any advice would be helpful.</p>
  
  <p>Edit :- <a href="http://technet.microsoft.com/en-us/magazine/2008.11.sql.aspx?pr=blog" rel="nofollow noreferrer">http://technet.microsoft.com/en-us/magazine/2008.11.sql.aspx?pr=blog</a></p>