Tuesday, July 1, 2008

Setting Auto-Recovery/AutoSave in SQL Server Management Studio

A recent forum post asked about how to configure the auto recovery / auto save options in SQL Server Management Studio.  I was surprised to find that you can't do any configuration of this in SSMS.  There are 2 connect feedbacks for this, both closed, and both unresolved.

Auto Save SQL Scripts option in Management Studio Feature Request
How to turn off Auto Recovery in SQL Server Management Studio 2005?

There is a work around published in one of them that will work.  You can edit the following registry key and set the Value of the AutoRecovery to 0(zero).

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

What is really surprising to me is that this also was not addressed in SQL 2008 as of RC0 either.  I would have expected that this would have been corrected, but have found that it wasn't.

No comments:

Post a Comment