Change Connection should order instance names in a better way

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

Closed

as Not Reproducible Help for as Not Reproducible

Type:	Suggestion
ID:	542304
Opened:	3/16/2010 10:08:23 AM
Access Restriction:	Public

Workaround(s)

view

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.

Details (expand)

English

Tools (SSMS, Agent, Profiler, etc.)

Keep track of the last time a server was connected to, and order the list based on that (in descending order, of course).

Faster Development

Improved Reliability

Improved User Interface

Improved Administration

0 attachments

Posted by Microsoft on 4/18/2011 at 12:41 AM

Hi,
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

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=424800

thanks
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).