Thanks Roy. I can probably get what I'm looking for by creating an extended events session. Setting those up seems to be a bit more involved though. ...

Forgot to include my version. One would think that if it works in 2008 SP2 then it would work in 2012.

Microsoft SQL Server 2012 - 11.0.5058.0 (X64)

May 14...

Is there a trick to getting the parameter values to show up in the sql statement that was run? For this sql:

DECLARE @lastName as varchar(50);

SET @lastName = 'Jones';

SELECT *...

I have the same problem. Just read this:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=281612

Haven't installed the hotfix yet but will let you know once it's done and tested.