Tagged Questions

2
votes
1answer
30 views

Audit full text activity

I need to find when and which user created full text catalog, and who added/modified/deleted the columns (that were full text indexed) in that full text catalog.
4
votes
3answers
77 views

Auditing specific database events

For auditing purposes, we have a requirement in which we have to enable Auditing for theses events: DBA Logins Changes made by DBAs LIKE INSERT, DELETE, UPDATE, ALTER (etc.) Changes made by our ...
2
votes
0answers
134 views

Auditing - parameter values not being written to log

I am using auditing to track usage of some procs in the database. In the log I can see a record for the Procedure being run and, immediately afterwards,the SQL statement that is being run. The ...
2
votes
1answer
315 views

How to Create Database Audit Specification for a column?

I am creating SQL Server 2008 R2 Database audit Specification for tblPerson.SSN I selected Audit Action Type: Update Object Class: Object Object Name: tblPerson Principal name: Public It captures ...