Search This Blog

Recently executed SQL Statements


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

No comments: