Auditing object activities | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Auditing object activities

I use SQL2000. My problem is that I want to switch on an audit trail for some tables but not for all ones. As I read in the help maybe the C2 auditing can help to solve my issue. Does somebody knows the C2 auditing option? And could you describe how to customize the objects I want to set up audit? Or send a link to a C2 admin guide? Or is there another possibility to solve my problem? Thanks,
Ggtb Ggtb.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx for informaton on C2 auditing, I don’t think there is such option to select set of objects for auditing. You may require third party tool or in house developed monitoring application. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Yes , you can use SQL Profiles or C2 Auditing
http://www.sqlservercentral.com/columnists/dasanka/basicsofc2auditing.asp
As Satya said better to use thrid party tool. there is a new tool DBAudit
http://www.softtreetech.com/download/dbaudit.exe
Thank you guys, I will try the DBAudit.
Ggtb.
Pl. share your experience with us on DBAudit
quote:Originally posted by ggtb Thank you guys, I will try the DBAudit.
Ggtb.

]]>