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 http://www.sql-server-performance.com/da_dbaudit_spotlight.asp —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

---

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.

---

]]>