| How to retrieve unsaved SQL query script or files?
There are many situation when SQL server Management Studio or some query window accidently closed before saving script. To retrive unsaved SQL query script we use below query:-
USE Database_Name
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
ORDER BY execquery.last_execution_time DESC
| | |