Auditing in SQL Server 2008

• am-244616

  SSCarpal Tunnel

  Points: 4936

  More actions

  March 3, 2009 at 3:17 pm

  #206489

  Guys,

  I was looking at the auditing capabilities of SQL 2008, it seems like it only audits the DML statements on a given table. It does not actually capture any before or after data images for DML actions. Is there a feature in SQL 2008 that can be used to capture data images before or after the dml action.

  Any suggestions/inputs would help.

  Thanks

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  March 3, 2009 at 7:25 pm

  #952825

  Have you checked this-->http://www.kodyaz.com/articles/change-data-capture.aspx

  MJ