What are the challenges you face when working across database platforms? Take the survey
Options

Configure Database Distribution Lists

gsc_ghxgsc_ghx Posts: 73
edited May 7, 2014 3:38PM in SQL Multi Script
When I installed Multiscript it automatically 'detected' a number of SQL Servers on our network. I had to add some that it did not find. I want to remove several of the servers it 'found' that I do not use nor have access to as they are developer's servers. How can I remove these automaticaly added servers? I can remove those that I add but not the ones that are automatically detected and added.

Thanks
Geri

Comments

  • Options
    Hi, and thanks for your post.

    When you click "Configure" in Multi Script, it'll search your network to give you a list of available servers. This works by running a query that partly relies on the SQL Browser service running on the servers, and could explain why some weren't listed and you had to add them manually (i.e. they couldn't be detected).

    Once you have the ones you want in the list, you then click "Add" to move the ones you want to actually work with over to the right. You can add them to the default list, or create a new list of servers by clicking "New" at the top, and entering a name - for instance, "Geri's list".

    Once you OK that, then you can select your list in the main SQL Multi Script screen and you'll just be working with the servers you want.

    Regarding your original query of removing servers from the selection screen, this isn't possible unfortunately, as a search is performed when you go into that screen. The idea here is to present you a list of as many servers as possible to minimise the need to add them manually. The lists enable you to then work with just the ones you want, so the extra ones aren't in the way.

    Hope that makes sense.
    Systems Software Engineer

    Redgate Software

  • Options
    facklecfacklec Posts: 7 New member
    The Configure Database Distribution List is missimg almost all of our servers and is showing many workstation I'm not interested in. We have about 30 SQL servers and only one is listed (we have probably 100+ servers and 5,000 workstations). I'd like to apply a filter (e.g. all servers like "SQL*" with the ability to use wildcards.
  • Options
    facklecfacklec Posts: 7 New member
    PS...
    It would be great if we can order the distribution list (or at least have them appear in alpabetical order).
Sign In or Register to comment.