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 vote155 views1 answer
Sp help text in postgresql
SQL
0 vote124 views1 answer
Remove default constraint sql server
SQL
0 vote133 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote163 views1 answer
Tsql cte in a transaction
SQL
0 vote145 views1 answer
Set root password mysql xampp
SQL
3 votes131 views2 answers
Create schema postgres
SQL
1 vote134 views1 answer
Mysql find most common value
SQL
28 votes129 views4 answers
Mysql delete database
SQL
0 vote130 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote124 views1 answer
Mariadb maximum left join
SQL