Get last run query sql server

Sql server last executed query

SELECT deqs.last_execution_time AS [Time], dest.text AS [Query], dest.*
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE dest.dbid = DB_ID('msdb')
ORDER BY deqs.last_execution_time DESC

SELECT dest.TEXT AS [Query],
deqs.execution_count [Count],
deqs.last_execution_time AS [Time]
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

Source: grepper.com

Similar codes

8 votes179 views2 answers
Sqlsrv default port
SQL
5 votes151 views1 answer
List foreign key oracle
SQL
0 vote170 views1 answer
Denormalise SQL command
SQL
0 vote175 views2 answers
Sql use not in
SQL
0 vote226 views1 answer
What is metadata in sql
SQL
0 vote186 views1 answer
Mysql reset wp_options
SQL
2 votes164 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
1 vote170 views2 answers
DROP TABLes regardless of constraints
SQL
1 vote171 views1 answer
Sql server today minus n
SQL
0 vote172 views1 answer
UNION ALL LEFT JOIN
SQL