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

2 votes196 views1 answer
Oracle kill job by sid
SQL
0 vote205 views1 answer
Sql show all users
SQL
2 votes216 views3 answers
Mysql list tables by size
SQL
9 votes212 views4 answers
Mysql show table fields
SQL
6 votes203 views1 answer
Sqlite foreign key
SQL
0 vote242 views1 answer
Select count postgres double row count > 1
SQL
2 votes200 views2 answers
Postgres trigger insert into another table
SQL
16 votes254 views3 answers
Order by sql query
SQL
0 vote192 views1 answer
Sql check for null and empty string
SQL
0 vote202 views1 answer
Mysql coonect sample code
SQL