Home Forums SQL Server 2012 SQL 2012 - General SSMS Auto-recovery/Auto-save new (unsaved) queries RE: SSMS Auto-recovery/Auto-save new (unsaved) queries
Oscar D. Garcia
SSC Eights!
Points: 874
More actions
October 5, 2014 at 12:34 pm
#1750196
This article points out the option to use the query statistic cache from SQL server. You can get the actual SQL using sys.dm_exec_sql_text.
Hope that helps:
http://ozkary.blogspot.com/2014/09/recover-sql-server-management-studio.html