I've set up a SQL server audit toÃÂ capture select statementsÃÂ against a table in my database.ÃÂ ÃÂ That's working great with no problems my question is when I view the selected row details of myÃÂ audit entry in the audit log I see the statement has been parameterized.ÃÂ Here's an example of whatÃÂ I mean, in a query window I execute:ÃÂ
select * from table where name = 'Smith'.ÃÂ ÃÂ
The audit entry displays the statement asÃÂ
select * from table where name = @0
ÃÂ My question is whether or not there is a way we can capture the where conditions in the audit event.
View Complete Post