How to find out recently run queries in SQL Server 2005?
Posted by Viral Sarvaiya on October 20, 2009
Select dmStats.last_execution_time as ‘Last Executed Time’, dmText.text as ‘Executed Query’ from sys.dm_exec_query_stats as dmStats Cross apply sys.dm_exec_sql_text(dmStats.sql_handle) as dmText Order By dmStats.last_execution_time desc


