Skip to content

Instantly share code, notes, and snippets.

@nire0510

nire0510/history.sql

Last active September 19, 2017 15:22
Show Gist options
  • Save nire0510/208afb23befc33da7546 to your computer and use it in GitHub Desktop.
Save nire0510/208afb23befc33da7546 to your computer and use it in GitHub Desktop.
Download ZIP
[MS SQL History] Search query in MSSQL queries history #database
Raw
history.sql
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'%PART_OF_YOUR_QUERY%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment