How to implement audit in sql server 2005

• p.avinash689

  SSC-Addicted

  Points: 435

  More actions

  May 30, 2014 at 3:08 am

  #291752

  Hi All,

  I need to implement change tracking on two tables in my SQL Server 2005 database. I need to audit additions, deletions, updates (with detail on what was updated). How can i do this.please help me if any documents by doing step by step please share to me.

  Thanks in Advance,

  Avinash P

• dbafromthecold@gmail.com

  SSChampion

  Points: 10160

  More actions

  May 30, 2014 at 7:16 am

  #1717760

  Would this help?

  http://www.mssqltips.com/sqlservertip/2121/event-notifications-in-sql-server-for-tracking-changes/