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 * FROM MyTable where lastname = @lastname;

The audit shows this was run:

SELECT * FROM MyTable where lastname = @lastname;

I want to see:

SELECT * FROM MyTable where lastname = 'Jones';