How to retrieve unsaved SQL query script or files?

1.	How to retrieve unsaved SQL query script or files?
Answer» 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

Discussion