Configure Database Distribution Lists

Single-click script execution on multiple SQL Servers.

Configure Database Distribution Lists

Postby gsc_ghx » Thu Sep 29, 2011 10:09 pm

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.

Posts: 51
Joined: Tue Dec 04, 2007 9:33 pm

Postby james.billings » Mon Oct 03, 2011 12:19 pm

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.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Most server missing in the Databases to Add

Postby facklec » Wed May 07, 2014 7:33 pm

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.
Posts: 5
Joined: Wed Jun 26, 2013 6:36 pm
Location: Olympia, WA

Order Distribution List

Postby facklec » Wed May 07, 2014 7:38 pm

It would be great if we can order the distribution list (or at least have them appear in alpabetical order).
Posts: 5
Joined: Wed Jun 26, 2013 6:36 pm
Location: Olympia, WA

Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests