Archive
Archive for November 13, 2017
Validate SQL Server Database Mail Settings
November 13, 2017
1 comment
In my last post, I shared a script to automate the migration of SQL Server Database Mail settings. In this post, I show how to send test e-mails from all Database Mail profiles on an instance. The migration I was working on contained 21 Database Mail profiles. The following script will send a test e-mail from each profile to confirm successful configuration. I hope you can put this code to use in your migrations.
Categories: SQL Server, SQL Server Database Mail, T-SQL
SQL Server, SQL Server Agent, T-SQL