Wednesday, June 24, 2009

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

0 comments:

Post a Comment