I have an application that relies on Database Mail for sending out alerts and notifications.
I have it working wonderfully... as long as I manually set up Database Mail.
How can I provide a script to take care of the details of setting up Database Mail?
Most of SQL Server Management Studio has a "script" button which will accept input, then generate a script to take the actions requested. This doesn't exist for the "Configure Database Mail" Wizard.
I was able to find "Database Mail Simple Configuration Template" in the template explorer. My main question is how to set one of the profiles as the default profile
View Complete Post