Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server Management Studio error "Saved settings file cannot be found"

Here is my problem: Every time I start the "Microsoft SQL Server Management Studio", I get a warning

The automatically saved settings file "\\Settings\CurrentSettings-2012-02-13.vssettings' cannot be found.

The message goes on to say :

"You can change this file on the 'Import and Export Settings' Tools Options page". The IDE will use your most recent settings for this session.

Where is this setting? How to fix this?

thanks!

like image 543
Wirianto Avatar asked Oct 05 '12 13:10

Wirianto


People also ask

How to import and export settings in SQL Server management studio?

However there is no option "Import and Export Settings" in SQL Server Management Studio. Edit the value of the Reg Key "VisualStudioLocation" to %USERPROFILE%\Documents\SQL Server Management Studio Now when you open or close SQL Server Management Studio, You will not get the error.

Does SQL Server management studio support extensibility?

SQL Server Management Studio is built upon the Visual Studio Isolated Shell, which inherently supports extensibility (add-ins/plug-ins). It is possible to tap into the Visual Studio extensibility services to surface custom capabilities within SQL Server Management Studio; however, such extensibility is not supported.

Where can I find Visual Studio 2015 settings for SQL Server?

Here is the text of the message. The automatically saved settings file ‘c:\users\<UserName>\documents\visual studio 2015\settings\sql server management studio\NewSettings.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 for this session.

How do I backup my Visual Studio 2008 settings?

In the Tools menu, select Options. In Automatically save my settings to this file, enter the location you will backup. Select OK. This file is in : %userprofile%\Documents\Visual Studio 2008\Settings\CurrentSettings.vssettings


2 Answers

you can try with theses steps :

In the Tools menu, select Options.

Select Environment folder, choose Import and Export Settings

In Automatically save my settings to this file, enter the location you will backup.

Select OK.

This file is in : %userprofile%\Documents\Visual Studio 2008\Settings\CurrentSettings.vssettings

Nota : if you don't find file, you can get another file from your coleague

like image 198
Aghilas Yakoub Avatar answered Nov 08 '22 13:11

Aghilas Yakoub


  1. If SQL Server Management Studio is open close it

  2. Open Registry Editor Navigate to the location _HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell_

  3. Edit the value of the Reg Key "VisualStudioLocation" to

    %USERPROFILE%\Documents\SQL Server Management Studio

Close Registry Editor and check if the problem is fixed

like image 21
Smith Avatar answered Nov 08 '22 13:11

Smith