Recover Crashed Query in SSMS – SQL in Sixty Seconds #116


 

Has it ever happened to you when you are working on a large SQL Server query and suddenly your SQL Server Management Studio (SSMS) crashes? Honestly, it has happened to me quite many times and it is indeed frustrating. Today we will learn about how we can recover crashed queries in SSMS.

The good thing is that when SSMS crashes at that time, it automatically saves all the work due to configuration settings in the SSMS. You can access that configuration by going to Tools >> Options >> Environment >> AutoRecover.

Here is the screenshot for the same.

Now due to any reason,