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

16 votes193 views4 answers
Sort by sql
SQL
0 vote198 views1 answer
Postgres list tables and row counts
SQL
0 vote225 views1 answer
Sql server create constraint
SQL
0 vote203 views1 answer
See Foreign Key
SQL
0 vote235 views1 answer
Mysql command line top 10
SQL
0 vote217 views1 answer
How to define a non primary composite key in sql
SQL
0 vote212 views2 answers
Sql stored procedure for access frontend
SQL
0 vote194 views1 answer
Postgres create extension if not exists
SQL
0 vote191 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote188 views1 answer
Oracle locked objects
SQL