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 vote263 views1 answer
Mysql sql select one day before
SQL
0 vote268 views1 answer
Mysql drop trigger
SQL
1 vote273 views1 answer
How to remove identity from a column in sql server
SQL
0 vote274 views1 answer
Into operator in sql
SQL
0 vote276 views1 answer
Postgresql show owner of database
SQL
0 vote286 views1 answer
Mysql remove bad character from all fields
SQL
0 vote276 views1 answer
Oracle change password expiration policy
SQL
1 vote259 views2 answers
Mysql type conversion
SQL
0 vote279 views1 answer
Openquery update linked server
SQL
13 votes297 views3 answers
List all the tables in sql
SQL