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

0 vote203 views2 answers
Starts and end with vowel sql
SQL
0 vote301 views1 answer
Postgres list all stored procedures query
SQL
0 vote178 views1 answer
Downgrading sql localdb visual studio
SQL
3 votes240 views1 answer
Sql select second max
SQL
6 votes202 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote182 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote204 views1 answer
Sql order by except one row
SQL
7 votes182 views1 answer
Safe update mysql
SQL
9 votes193 views2 answers
Sql limit order by
SQL
0 vote206 views1 answer
What is server_default = func.now() in sqlalchemy
SQL