Tuesday 7 July 2015

Recover unsaved SQL query scripts

 Use <your database>
SELECT execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery
CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql
where execsql.text like '% something you remember or commd this where condition %'
ORDER BY execquery.last_execution_time DESC

No comments:

Post a Comment