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 vote118 views4 answers
Database stuck at restoring state
SQL
0 vote70 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote111 views1 answer
Replace multiple string in query sql
SQL
0 vote131 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
1 vote110 views1 answer
Psql show with user is logged in
SQL
0 vote163 views1 answer
Postgres list all stored procedures query
SQL
0 vote145 views2 answers
Check if sql temp table exists
SQL
0 vote106 views1 answer
Change default schema sql server
SQL
1 vote62 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote116 views1 answer
Typeorm raw sql
SQL