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

3 votes303 views2 answers
Mysql add 2 hours
SQL
0 vote316 views1 answer
Check duplicate values plsql
SQL
7 votes380 views3 answers
Sql server check if temp table exists
SQL
0 vote327 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote306 views1 answer
SQL get max per id
SQL
1 vote323 views1 answer
Count mysql server db tables
SQL
1 vote352 views1 answer
Mamp mysql path mac
SQL
40 votes422 views4 answers
PostgreSQL add column
SQL
1 vote314 views1 answer
Sql auto date
SQL
13 votes298 views5 answers
Oracle list tables
SQL