I am using auditing to track usage of some procs in the database. In the log I can see a record for the Procedure being run and, immediately afterwards,the SQL statement that is being run. The statement shows the parameter name rather then the value i.e.
WHERE CaseId=@P_CaseId rather than
WHERE CaseId =100
Now I know there was a hotfix for SQL 2008 (not R2) that made this happen: http://support.microsoft.com/kb/967552.
Did this not get rolled into R2? Is there a different fix I can apply? Is there a workaround anyone knows?