Thursday, January 27, 2011

Get Last Executed Query with Time

Using below query you can easily trace the query that are executed earlier..


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

No comments:

Post a Comment