Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 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%'
share|improve this question

migrated from serverfault.com Aug 17 '12 at 1:31

This question came from our site for professional system and network administrators.

    
If you want to audit changes to just one column, I suggest you use a trigger instead. –  HLGEM Aug 17 '12 at 14:10

1 Answer 1

I am not sure you can. However it is a bit confusing, MSDN says that it is possible:

http://msdn.microsoft.com/en-us/library/cc280645(v=sql.105)

However following the example that they give I get the following error:

Msg 33211, Level 15, State 1, Line 0 A list of subentities, such as columns, cannot be specified for entity-level audits.

The message above seems to be pretty definitive, I have tried their example on 2008, 2008 R2 and 2012 and I get the same message every time.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.