posted on Friday, February 16, 2007 11:53 AM
by
mz1313
Saving Auto Recovery Information
If you have bad luck of working with Management Studio via VPN connection (maybe other slow connections as well - I experience it only via VPN), I'm sure that you're familiar with this situation: your screen is frozen, you stare on it with angry look on your face and see just a small line in a bottom left corner of your Management Studio saying: "Saving Auto Recovery Information". Last time when I worked from home with my version script (about 50K rows), the "Saving..." process had been taking about 5 minutes every time. So, here is the way to get rid of it. Go to Registry and change to 0 (zero) value of the following key:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\AutoRecover\AutoRecover Enabled