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

2 votes194 views3 answers
Xampp mysql database not starting
SQL
0 vote157 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote137 views1 answer
How to connect pgadmin with excel
SQL
0 vote218 views1 answer
Placements hackerrank solution
SQL
0 vote163 views3 answers
Mysql regex replace
SQL
0 vote156 views1 answer
T-SQL - Where Used List (Table/View)
SQL
1 vote145 views1 answer
Show all event schedular on mysql
SQL
1 vote148 views1 answer
Oracle duration between timestamps
SQL
0 vote193 views1 answer
Mysql select random rows large table
SQL
0 vote156 views1 answer
Enable sql server full text indexing
SQL