SELECT last_execution_time , [text] AS [Statement]
FROM
sys.dm_exec_query_stats
CROSS
APPLY
sys.dm_exec_sql_text(sql_handle)
ORDER
BY last_execution_time DESC
SELECT last_execution_time , [text] AS [Statement]
FROM
sys.dm_exec_query_stats
CROSS
APPLY
sys.dm_exec_sql_text(sql_handle)
ORDER
BY last_execution_time DESC
Post a Comment
Post a Comment