My question is that how can we see parameter values in the Audit log in SQL Server 2008? Currently, instead of showing parameter values parameter names are being displayed in the the log. For ex. if I write a query like
Declare @v as int
set @v = 1
select * from Emp where id = @v
when I execute this query, it is being logged as "select * from Emp where id = @v".But I want to see parameter values instead of parameter names, How can I achive this in SQL Server 2008 Auditing?
View Complete Post