SQL SERVER – 2005 – Last Ran Query – Recently Ran Query | Journey to SQL Authority with Pinal Dave

How many times we have wondered what were the last few queries ran on SQL Server? Following quick script demonstrates last ran query along with the time it was executed on SQL Server 2005. 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 Reference… Continue Reading...

Source: SQL SERVER – 2005 – Last Ran Query – Recently Ran Query | Journey to SQL Authority with Pinal Dave