Audit for altering of records in user tables | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Audit for altering of records in user tables

Hi, I am using sp_trace_* extended stored procedures to perform audit trace.
The requirement to logged activities than selecting or altering records in user tables in non-system databases.
Is there a filter or customization of events in profiler stored procedures that can achieve this?

How about using a third party tool such as DBAudit Expert. DBAudti Expert create triggers on your tables to capture the activities on them —————————————-
Cast your vote

Thanks for that suggestion. I am considering to archieve it using features out of the box from MSSQL. So, does that means it is impossible to log SELECT, INSERT, UPDATE, DELETE, EXECUTE just on user tables/procedures using profiler.