SQL Server Management Studio (SSMS) - How to switch off Auto Recover Option?

In spite of having more critical deliverables for today, I still wanted to post this article, because of it's importance.



This particular issue is no less than an acute pain. And I mean it.

In SQL Server Management Studio, from versions 2005 till 2008, there is an option called "Auto Recover" which triggers a process that save whatever we are writing in the Query Editor... every 5 to 10 mins. And that's real pain for us, especially if we are working on remote or thru' internet.

Sometimes, the system gets hung for so long that you would sit in front and wait till it "recovers" from the "recovery" itself.

BUT, there IS a solution which is unsupported by Microsoft SQL Server team, but harmless and effective. There is a registry entry called "AutoRecover Enabled", which by default is set to 1. We have to change it to 0. This will not trigger that painful process anymore.

Do a find in Registry Editor for the above option, and you would be able to see that.

References for this solution:

1. http://connect.microsoft.com/SQLServer/feedback/details/125840/how-to-turn-off-auto-recovery-in-sql-server-management-studio-2005
2. http://blog-mstechnology.blogspot.com/2009/06/turn-off-saving-auto-recovery.html

We are thru'... Enjoy a Hang-Free SQL Session...!!!

VAIDY