Get the last executed sql queries on MS-SQL

Last_Executed_Queries.sql

SELECT TOP 100 
     qt.text AS sql_query 
	,qs.last_execution_time 
	,qs.execution_count 
	,sd.name AS db 
FROM sys.dm_exec_query_stats AS qs 

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt 

OUTER APPLY 
	(
		SELECT CAST(pa.value AS int) AS db_identifier 
		FROM sys.dm_exec_plan_attributes(qs.plan_handle) AS pa 
		WHERE pa.attribute = 'dbid' 
		-- Each execution plan has many attributes (like dbid, object_id, set_options, etc.)
		-- The DMV returns them as rows, not columns
	) AS plan_attributes 

LEFT JOIN sys.databases AS sd ON sd.database_id = plan_attributes.db_identifier 

WHERE (1=1) 
AND sd.database_id > 4 -- Filter out system DBs (IDs 1-4) 
	
	-- AND qs.last_execution_time >= DATEADD(week, -1, CURRENT_TIMESTAMP) 
	AND sd.name = 'YOUR_DB_NAME_HERE' 
	
ORDER BY qs.last_execution_time DESC
;