Answers for "sql server get log of queries"

SQL
1

sql server 2012 query history

SELECT t.[text]
FROM sys.dm_exec_cached_plans AS p
CROSS APPLY sys.dm_exec_sql_text(p.plan_handle) AS t
WHERE t.[text] LIKE N'%something unique about your query%';
Posted by: Guest on October-31-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language