Geek Answers Handbook

How to clear the drop-down list of logins from the invitation to connect to sql server 2008 server management studio?

I connected to several databases once and only once, and you won’t need it anymore, but they clutter up the drop-down list of available for login.

How can I reset the list of servers and logins from the command line in SQL Server Management Studio Express 2008?

+5
source share
4 answers

In SSMS 2008, if you rename a file SqlStudio.bin, say SqlStudio.BAK, then SSMS will re-create the file when you reopen the application. All servers and logins will be forgotten.

Link

+5
source

SQL Server Management Studio 2008 , -, ...

% SYSTEMDRIVE%\Documents and Settings\%USERNAME%\ \Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

, . Microsoft.SqlServer.Management.UserSettings.ServerConnectionSettings, .

, . , .:)

+3

( - - ) mru.dat :

% %\Application \Microsoft\Microsoft SQL Server\90\Tools\Shell\

NOTE : my version is il 2005, so you may find that your path is a little different.

+1
source

Vista user can update DialogSettings.xml. This file may be located in the following location.

C: \ Users [UserName] \ AppData \ Roaming \ Microsoft \ Microsoft SQL Server \ 90 \ Tools \ Shell

0
source

More articles:


All Articles