In sql server maangement studio 2008 and 2005, how do I sort alphabetize "registered servers" list of my servers?

Posted on 2011-05-02
Last Modified: 2012-05-11
In SSMS, in the window REGISTERED SERVERS, Database Engine, Local Server Groups, I have a list of my registered servers but they are not alphabetized and I was wondering if anyone knew how to do this?

Question by:paultran00
    LVL 9

    Accepted Solution

    SSMS Object explorer lists only connected server. And it is sorted on order which the connections were made. And there is no way you can sort them alphabetically. But you can disconnect and connect servers as you want. There is no need to have them all in the SSMS OE all the time.
    LVL 59

    Assisted Solution

    by:Kevin Cross
    In the Registered Servers view, mine auto sorts by the registered server name.  If they are all just instances of the same server, maybe that is the issue -- try naming them functionally OR using something like '1 SERVERNAME', '2 SERVERNAME\INSTANCE2', etc.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now