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 vote168 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote167 views1 answer
Postgres create extension if not exists
SQL
4 votes197 views1 answer
Sql delete multiple conditions
SQL
0 vote137 views1 answer
Create duplicate table postgres
SQL
1 vote185 views3 answers
Psql fatal database does not exist
SQL
5 votes163 views1 answer
Minecraft java port number
SQL
1 vote160 views1 answer
Sql trigger before delete
SQL
0 vote138 views1 answer
Login phpmyadmin without password
SQL
1 vote187 views5 answers
Sql 2nd highest salary
SQL
0 vote165 views1 answer
Mysql in clausule string array
SQL