Hi Brian,

Very nice article. I was able to configure the auditing but I am not getting the parameter values in the audit.

Ex. If some executed a query as follows:

select name, age from dbo.employees where empno = 100.

This above query is being audited as follows:

select name, age from dbo.employees where empno = @1.

How can I get the value of @1?

Regards,

Atiq Rahman