Posted onJanuary 5, 2016 by Josephine lost your query in ssms? – use DMOs to retrieve SELECT dest.text FROM sys.dm_exec_query_stats AS deqs CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest WHERE deqs.last_execution_time > ’12/28/15 11:00′ AND dest.text LIKE ‘%DROP%’;