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 vote142 views1 answer
Multiple like values for single column postgres
SQL
0 vote118 views1 answer
Oracle execute package dblink
SQL
0 vote108 views1 answer
Date 3 months from today sql
SQL
0 vote108 views1 answer
Drop all triggers oracle
SQL
1 vote106 views1 answer
Get rows affected mysql python
SQL
0 vote176 views4 answers
Stored procedure sql
SQL
0 vote107 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote156 views1 answer
Mysql collation portugues brasil
SQL
1 vote142 views1 answer
Insert many to many sql
SQL
-2 votes115 views1 answer
Mysql see users and passwords
SQL