Nilay
Thursday, 19 May 2011
T-SQL Query
Recently Executed T-SQL Query
:
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
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment