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

25 votes198 views1 answer
Mysql grant all privileges to a user
SQL
5 votes194 views1 answer
How to check nls timestamp format in oracle
SQL
2 votes241 views1 answer
How to delete all duplicate items in mysql
SQL
4 votes215 views1 answer
Sql data types
SQL
0 vote202 views1 answer
Sql find leading space
SQL
2 votes221 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
1 vote203 views1 answer
Alphabetical order mysql
SQL
2 votes224 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
3 votes200 views2 answers
Sql asc
SQL
0 vote203 views1 answer
Postgresql default value boolean
SQL