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.
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.