I am creating SQL Server 2008 R2 Database audit Specification for tblPerson.SSN
Audit Action Type: Update Object Class: Object Object Name: tblPerson Principal name: Public
It captures all changes to the table. How could I see just one column?
I could filter my column out
select statement,* from fn_get_audit_file ('q:\SQLBackup\*',null,null) where statement like '%SSN%'