When you try to Open or Close SQL Server Management Studio after an upgrade or fresh installation of SQL Server 2008 R2 you might get the below error which states,
However there is no option "Import and Export Settings" in SQL Server Management Studio.
So to Fix this error,
The automatically saved settings file '\\Settings\CurrentSettings-YYYY-MM-DD.vssettings' cannot be found. You can change this file on the 'Import and Export Settings' Tools Options page. The IDE will use your most recent settings file for this session. |
However there is no option "Import and Export Settings" in SQL Server Management Studio.
So to Fix this error,
- Open Registry Editor
- Navigate to the location HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell
- Edit the value of the Reg Key "VisualStudioLocation" to %USERPROFILE%\Documents\SQL Server Management Studio
- Close Registry Editor
Now when you open or close SQL Server Management Studio, You will not get the error.
15 comments:
Thanks, its working
Perfect! I also saw some other goodies in there that I wanted to change. Thanks for posting!
Cool It's working Thanks...
Perfect, this also works for me!
Thank you Very Much, It's working ;)
Thanks its help me
AWESOME!! Thank you....this has been driving me nuts for weeks.
Excellent..!!
Edit the value of the Reg Key "VisualStudioLocation" to %USERPROFILE%\Documents\SQL Server Management Studio
bước này làm như nào vậy mọi người
http://stackoverflow.com/questions/27623262/sql-server-management-studio-error-saved-settings-file-cannot-be-found-virtual
Not working for me
Thank You
after reaching the following location i am not able to find microsoft sql server
HKEY_CURRENT_USER\Software\Microsoft\ "microsoft sql server" file
how could i proceed...help me up please.
you can say that green health is the best because it is all organic’ https://royalcbd.com/product/cbd-oil-2500mg/
Aivivu - đại lý chuyên vé máy bay trong nước và quốc tế
vé máy bay đi Mỹ bao nhiêu tiền
các chuyến bay từ mỹ về việt nam
có chuyến bay từ nhật về việt nam chưa
chuyến bay từ frankfurt đến hà nội
giá vé máy bay từ Vancouver về việt nam
Lịch bay từ Hàn Quốc về Việt Nam tháng 7
khách sạn cách ly
vé máy bay cho chuyên gia nước ngoài
Not working for me
Post a Comment