Post reply

Table Data Auditing

  • June 27, 2008 at 9:29 am

    #187643

    Hello,

    We have a few hundred tables in the database and we need to audit (capture logs) of the changes made to certain tables (such as insert, delete, update) and store them in a separate table. The stored data will be later used, changes analzyed and actions are taken..

    Now, in order to capture the logs, is there an efficient way to do this other than to write triggers in each of those tables that we want to audit?.

    Any suggestions appreciated.

    Thanks.

    Ganesh

  • June 27, 2008 at 12:14 pm

    #835559

    http://qa.sqlservercentral.com/articles/Auditing/63247/

    http://qa.sqlservercentral.com/articles/Auditing/63248/

    These two articles and their discussions have a bunch of data on how to implement logging, pros and cons of different methods, etc.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • May 27, 2010 at 5:53 pm

    #1173659

    Object level auditing can be achieved in SQL 2008 easily

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply