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 votes533 views5 answers
Unique in sql server
SQL
14 votes406 views1 answer
How to export db from mysql
SQL
0 vote343 views1 answer
Get initials name in sql
SQL
7 votes312 views1 answer
Mysql unsafe update
SQL
2 votes322 views1 answer
Postgresql drop primary key constraint
SQL
0 vote334 views1 answer
Set classpath for mysql-connector.jar
SQL
34 votes399 views6 answers
Alter table add foreign key mysql
SQL
0 vote322 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
3 votes344 views4 answers
Order by desc postgres
SQL
0 vote348 views1 answer
Savepoint mysql script
SQL