Dynamic Distribution Lists

almasmithalmasmith Posts: 10
edited September 10, 2010 1:52PM in SQL Multi Script
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.
Sign In or Register to comment.