Audit table

• Satya_0000

  Mr or Mrs. 500

  Points: 544

  More actions

  December 6, 2011 at 4:36 am

  #251598

  I want a audit on table which can provide me records deleted ,updated ,insert and also select if possible.

• salum

  SSCommitted

  Points: 1598

  More actions

  December 6, 2011 at 4:44 am

  #1417219

  you can do it with DML triggers and it will work only for delete , insert and update not for select.

  http://blog.sqlauthority.com/2009/08/15/sql-server-introduction-to-change-data-capture-cdc-in-sql-server-2008/

  and if you using sqlserver 2008 you can try new CDC feature.

  http://blog.sqlauthority.com/2009/08/15/sql-server-introduction-to-change-data-capture-cdc-in-sql-server-2008/

  java[/url]

• Satya_0000

  Mr or Mrs. 500

  Points: 544

  More actions

  December 6, 2011 at 4:47 am

  #1417222

  Thanks for your quick reply.

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  December 6, 2011 at 5:32 am

  #1417267

  salum (12/6/2011)

  ---

  you can do it with DML triggers and it will work only for delete , insert and update not for select.

  http://blog.sqlauthority.com/2009/08/15/sql-server-introduction-to-change-data-capture-cdc-in-sql-server-2008/

  and if you using sqlserver 2008 you can try new CDC feature.

  http://blog.sqlauthority.com/2009/08/15/sql-server-introduction-to-change-data-capture-cdc-in-sql-server-2008/%5B/quote%5D

  Recommended Reading: What, When and who? Auditing 101

  http://www.sqlservercentral.com/articles/Auditing/75790/