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 vote187 views1 answer
Str_to_date sql server
SQL
-1 vote180 views1 answer
Sql select data from one database and insert into a different database
SQL
1 vote182 views1 answer
Show table status command in mysql
SQL
0 vote177 views1 answer
Guid string to binary better
SQL
0 vote196 views1 answer
Sql create and grant user access to database
SQL
16 votes195 views3 answers
Get count of duplicate records
SQL
1 vote197 views1 answer
Mysql connect bash
SQL
0 vote170 views1 answer
Sql server express download
SQL
13 votes195 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote178 views2 answers
Sql query in dax power bi
SQL