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 vote346 views1 answer
Site:av.ru "files"
SQL
0 vote323 views1 answer
Dataframe lambda elif
SQL
1 vote331 views1 answer
How to see logical reads in sql server
SQL
1 vote275 views1 answer
Mysql column start with string
SQL
1 vote296 views3 answers
Mysql Server Start
SQL
3 votes370 views1 answer
Oracle nextval insert
SQL
0 vote291 views1 answer
Renombrar tabla mysql
SQL
1 vote292 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote286 views1 answer
Mysql set boolean default value
SQL
0 vote320 views2 answers
T sql null or empty string
SQL