在SQL Server Management Studio中更改自动恢复信息的位置
我们的本地IT在网络路径上具有我的文档"文件夹.这会导致MSQL Server Management Studio出现问题，因为它会每10分钟保存一次自动恢复信息，并会在保存时锁定.
Our local IT has our My Documents folder on a network path. This causes a problem from MSQL Server management studio as it saves it auto recovery information every 10 min it will lock up as its doing its save.
我找到了VS2008保存设置的位置，但是我找不到如何从我的文档"中更改它的设置.有谁知道该设置的位置?
I found where VS2008 saved its setting but I can not find out how to change it out of My Documents for this. Does anyone know where that setting is located?
不幸的是，至少对于VS2005和VS2008(我认为是VS2010，但我没有检查过)，无法从系统的我的文件"文件夹.我同意，这很烦人，因为我们将我的文档"文件夹设置为网络共享.当我们使用VPN时，网络连接非常慢，因此自动恢复功能不是即时的，并且会阻止UI.
Unfortunately, at least for VS2005 and VS2008 (and I think for VS2010, but I haven't checked there), this cannot be changed from the system's "My Documents" folder. This is terribly annoying, I agree, as we have our My Docs folder set to a network share. When we're on VPN, the network connection is very slow, so the auto-recovery feature isn't instantaneous and blocks the UI.
我在Microsoft Connect上发现此反馈，该反馈指示无法更改设置:
I found this feedback on Microsoft Connect that indicates the inability to change the setting: Saving Auto Recover Information in Visual Studio 2008 SP1
替代品"很少.您当然可以关闭自动恢复"，但是通常不建议这样做.我最终决定要做的只是增加自动保存之间的时间间隔.在Tools \ Options \ Environment \ AutoRecover(在VS2008中)下，可以找到该位置，您可以在同一位置打开/关闭它.
There are few "alternatives." You could, of course, turn off Auto-Recovery, but that's not generally recommended. What I've ultimately decided to do is simply increase the time interval between auto-saves. This is found under Tools\Options\Environment\AutoRecover (in VS2008), which is the same place you would go to turn it on/off.
当然，在SQL Server Management Studio中，选项中没有环境\自动恢复"部分.但是，如果我们记得SSMS使用了Visual Studio核心(并且对注册表黑客行为感到满意)，那么我们也可以调整SSMS的时间间隔.
Of course, in SQL Server Management Studio, there is no Environment\AutoRecover section in the options. However, if we remember that SSMS uses the Visual Studio core (and we're comfortable with a bit of registry hacking), we can adjust the time interval for SSMS, as well.
VS使用名为自动恢复保存间隔"的REG_DWORD值存储两次自动保存之间的分钟数.只需将该值添加到注册表中的以下项即可(这适用于SSMS2008).我将我的值设置为60，因为我通常不会在SSMS中做很多超临界工作，但是您可以将其设置为适合您的值.
VS uses a REG_DWORD value named "AutoRecover Save Interval" to store the number of minutes between auto-saves. Just add that value to the following key in the registry (this is for SSMS2008). I set mine to 60 because I don't usually do much super-critical work in SSMS, but you can set it to a value that suites you.
HKEY_CURRENT_USER \ Software \ Microsoft \ Microsoft SQL Server \ 100 \ Tools \ Shell \ General \ AutoRecover
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\General\AutoRecover
我意识到这并不是解决原始问题的方法，但我认为至少是一个可行的选择.
I realize this isn't really a solution to the original issue, but I think it's at least a viable alternative.