Home > SQL Server, SQL Server Database Mail, T-SQL > Validate SQL Server Database Mail Settings

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.


  1. No comments yet.
  1. November 15, 2017 at 07:11

Leave a Reply

%d bloggers like this: