Dynamic Distribution Lists

Single-click script execution on multiple SQL Servers.

Dynamic Distribution Lists

Postby almasmith » Fri Sep 10, 2010 6:52 pm

Is there a way to create a dynamic distribution list. I manage over 200 databases on several different builds and would like to have my distribution list created at runtime based on something like this:

SELECT DatabaseName
FROM Customers
WHERE Build = 4.00.008

Customers change builds frequently as they request access to newly developed features and so I basically have to recreate my distribution list every time I deploy a hot-fix to a specific build.

I cannot see any way to do this in the UI, but I was wondering where the distribution lists are stored. Then I can just create a script to generate that file before any hot-fixes.

Thank you for your help.
almasmith
 
Posts: 7
Joined: Tue Jan 26, 2010 10:55 pm

Return to SQL Multi Script 1

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests