‘Saving Auto Recovery Information’ Window hang in SSMS

Came across this a couple of weeks ago in that while writing some T-SQL in Management studio 2008, the SSMS window started hanging intermittently due to ‘Saving Auto Recovery Information’.

This looks to have been a similar issue in SSMS 2005 – http://connect.microsoft.com/SQLServer/feedback/details/125840/how-to-turn-off-auto-recovery-in-sql-server-management-studio-2005

As far as i know, the only way to turn off this option is to edit the registry. (Editing the registry is dangerous – All the standard caveats about editing the registry apply! Do at your own risk)

Within Regedit, go to:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover

Edit the AutoRecover Enabled Key to be 0.

To re-enable this feature, set the key to 1


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: