Recently run queries WITH parameter values
11:57 25 Aug 2011

Trying to get the recently run queries on SQL Server. I can currently do this by running the query below, however this does NOT show me the parameter values.

Is there any way to get this as well?

SELECT 
    deqs.last_execution_time AS [Time], dest.TEXT AS [Query]
FROM 
    sys.dm_exec_query_stats AS deqs  
CROSS APPLY 
    sys.dm_exec_sql_text(deqs.sql_handle) AS dest
ORDER BY 
    deqs.last_execution_time DESC

Thanks Bruce

sql sql-server