Post reply

Auditing SQL Server 2005 Standard Database on Insert Update and Delete operations

  • February 11, 2013 at 12:10 am

    #270608

    Hi

    I have doubt about data Auditing in SQL Server 2005 EE.

    Is SQL Server 2005 has any default data Auditing for DML Operations?

    Kindly Suggest me.

    --Ragu Thangavel

  • February 11, 2013 at 6:53 am

    #1586529

    Some DDL yes, but nothing by default for DML. You would have had to have a Trace running to capture the DML activity.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 12, 2013 at 2:25 am

    #1586886

    I use auditing tables for capturing data changes. The auditing tables are updated via triggers whenever an insert or update occurs. The Inserted/Updated rows are copied from the base tabe to the audited tables. This will work for specific tables, but not something you would want to add accross a large number of tables.

    Thanks

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

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