April 17, 2011 at 11:17 pm
Hi,
I would like to ask whether it is possible in SQL 2008, when creating database audit specifications, to specify Column Level. Whenever a column is "touched" (ex. updated), to start auditing.
I know that you can specify the whole table, but I am interesting more in lower level (column level).
Thank you!
April 18, 2011 at 7:14 am
It doesn't appear you can audit at the column level.
From BOL (http://msdn.microsoft.com/en-us/library/cc280663.aspx):
Considerations
Database-level audit actions do not apply to Columns.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 18, 2011 at 7:45 am
asterman_3 (4/17/2011)
Hi,I would like to ask whether it is possible in SQL 2008, when creating database audit specifications, to specify Column Level. Whenever a column is "touched" (ex. updated), to start auditing.
I know that you can specify the whole table, but I am interesting more in lower level (column level).
Thank you!
You can have trigger or CDC(Change data capture) or Change tracking. More opitions are there you need to choose as per your need.
Thanks
Parthi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply