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

7 votes323 views1 answer
Grant schema permissions postgres
SQL
9 votes354 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote362 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote374 views1 answer
Sql log file inof
SQL
-1 vote372 views5 answers
Left join
SQL
0 vote353 views1 answer
Isnull in sqlite
SQL
3 votes319 views1 answer
What is having clause
SQL
-1 vote297 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote335 views1 answer
Get number of tables in database sql
SQL
1 vote368 views2 answers
Backup table mssql
SQL