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

7 votes255 views2 answers
Get database size mysql
SQL
0 vote268 views1 answer
Sqlite commands
SQL
0 vote260 views1 answer
Get the First and Last Word from a String or Sentence
SQL
1 vote276 views1 answer
Sql dcl
SQL
0 vote262 views1 answer
Select from another database
SQL
0 vote288 views1 answer
Faire une recherche par liste de mot clé sql
SQL
16 votes294 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote218 views1 answer
Check id exist or not in sql
SQL
0 vote310 views1 answer
How to check rollback status in oracle
SQL
0 vote278 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL