Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


24
0
Sign in
to vote
Type: Suggestion
ID: 542304
Opened: 3/16/2010 10:08:23 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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
Sign in to post a comment.
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).
Sign in to post a workaround.