Click here to Skip to main content
14,923,030 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

Sometimes i have faced in my machine all the servernames are cleared in SSMS "clear the server list in SQL Server Management Studio". How to avoid the problems

Can anyone help on this. Thanks in advance.
Posted
Updated 5-Jan-15 3:33am
v2

Further to solution 1 here are some other suggestions
http://blog.sqlauthority.com/2008/11/05/sql-server-clear-drop-down-list-of-recent-connection-from-sql-server-management-studio/[^] and http://blogs.msdn.com/b/managingsql/archive/2011/07/13/deleting-old-server-names-from-quot-connect-to-server-quot-dialog-in-ssms.aspx[^]

The wording of your post suggests that the list is getting cleared when you are not expecting it to be. In which case look at the ways it can get cleared from the links in these solutions and make sure you are not doing any of them inadvertently.

Also make sure you are using the same user credentials as these are per-user settings
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900