Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
Just checking, but did you read the More Information section of that article? The fix only applies to certain situations (most, but not all). –  Jon Seigel Sep 14 '12 at 16:49
I've tried both parameterization settings - but I'm on R2 where the behaviour seems to be the same, but there's no explicit fix for R2 (that I can see) so I'm confused. Was it not changed in R2? –  Rikalous Sep 18 '12 at 10:53
I assume the fixed behaviour in 2008 would carry over to R2. I was just checking to make sure that none of the exceptions apply to your situation. –  Jon Seigel Sep 18 '12 at 15:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.