Validate SQL Server Database Mail Settings
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
Comments (0)
Trackbacks (1)
Leave a comment
Trackback
-
November 15, 2017 at 07:11Validating Database Mail – Curated SQL
Chicago Data Professionals
