Remove Dead Servers

Posted on 2005-04-28
Last Modified: 2010-03-19
I have server names in enerprise manager. One was my laptop, one was another machine no longer running. How do I get rid f them? You have to connect to delete and there's nothing to connect to.Chris
Question by:stopher2475
    LVL 28

    Expert Comment

    Did you try to right-click on the Server name and select Delete SQL Server Registration?  Is this what you're looking for?
    LVL 2

    Author Comment

    This is what I would like to do, however, you must connect to the server to get this menu and as these machines don't exist I can't connect to them.
    LVL 28

    Accepted Solution

    >> you must connect to the server to get this menu <<

    I just tried right-clicking on the Server name that no longer exists and it showed me the menu where I was able to select Delete SQL Server Registration and I am not connected to it.  What version of SQL Server are you using?  I don't think you need to be connected to the server to do this.
    LVL 2

    Author Comment

    I just tried again and it's letting me delete without connecting.
    I swear I'm not crazy and I tried this before but didn't work.
    It still tries to connect if I move the mouse at all but at least I can get rid of the dead links.
    Anyhow, thanks for the help.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    730 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

    17 Experts available now in Live!

    Get 1:1 Help Now