Change Connection should order instance names in a better way - by Adam Machanic

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 542304 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 3/16/2010 10:08:23 AM
Access Restriction Public


When you click "Change Connection" the "Server name" pulldown contains all of the servers to which you've connected, in a seemingly random order. Up at the top of my list, at the moment, are servers to which I haven't connected in several months. Below those are servers to which I connect several times a day. 

It would be nice if SSMS could automatically "age" names down the list, so that the top of the list contains the most recently used names. This would save both time and the aggravation of having to scroll through a long list of names looking for something that you know must be there because you connected not even 10 minutes ago.
Sign in to post a comment.
Posted by Microsoft on 4/18/2011 at 12:41 AM
Thanks for the feedback. In SSMS, we always age down the connected server's name. The latest connected server names comes at the top.
We have also added functionality to delete the names from Server MRU list, which you will be able to see in upcoming release of Sql Server.
Here is the link for the related issue

Devesh Nagpal
Posted by F_clef on 3/19/2010 at 11:40 AM
... or even ordered alphabethically to make them easier to find in the list.
Posted by Ra Osolage on 3/16/2010 at 11:11 AM
Alternately, you could do auto-suggest. I think that would work out MUCH better.
Posted by AaronBertrand on 3/16/2010 at 10:46 AM
Would also be great if a server wasn't duplicated if you've connected in different ways (SQL vs. Win Auth, for example).