I am working on creating audit policy for SQL server tables for my application. I need to track all the insertion/updation/and deletion operations on the tables so that this can be used for the audit reports. I am planning to create audit table with the same structure for each table and define triggers on the main table to populate the audit table. I have found that in SQL 2008 audit features has been introduced. Has anyone used this feature? shall I drop my plan of manual auditing and start using 2008 auditing feature or any other suggestion?