Auditing in sql server 2008

  • Hi all,

    i am using sql server 2008.

    for auditing purpose triggers or best or Change data capture is best?

    regarding performance issue which is the best one to use?

  • What are you planning to audit.

    By the way, in SQL Server 2008 there is a new cool feature called AUDIT.

    You will find it in Management Studio. You could plan to use it.

    M&M

  • i have to audit changed data..

    tell me which is best one(triggers or cdc) to use regarding performance issue..

  • Hi Moinu,

    Is there anyway to purge the audit file based upon the time stamp?

    Thanks,

    Boj.

  • SQL Server 2008 has a new feature for Auditing. You can audit anything happening on the SQL Server using this feature. Its a full pledged Audit implementation and it's very granular. You can audit the select queries of as single user on a single table in a database. It's that granular. Also its very simple to implement. You can audit all the DDL, DML and server login activities.

    Change Data Capture is also a very good feature of SQL 2008. It's available only in Enterprise edition. It can be used to track the DDL happening on the tables.

    Triggers can also be used. But that require considerable effort on your part to code them properly. If not written properly they cause lot of headaches.

    I'd prefer CDC to Triggers. BTW, what are you planning to achieve ?

    Thank You,

    Best Regards,

    SQLBuddy

Viewing 5 posts - 1 through 4 (of 4 total)

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