How to see query history in SQL Server Management Studio
發表於 : 2015-02-06 13:55:11
http://stackoverflow.com/questions/529 ... nt-studio
代碼: 選擇全部
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%';