MSSQL - Recover your SQL when SSMS crashes

Last runs SQL scripts from execution history

This script can only work without server restart

Use DataWarehouse

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