How Can We Help?

Get the List of all the queries executed on a Particular SQL Database

Created On
bytechnologyjunction
You are here:
← All Topics

Use [DB NAME]
SELECT execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery
CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql
ORDER BY execquery.last_execution_time DESC

Table of Contents