DataBase Mail component

Database Mail is a convenient and easy way to send alerts, reports, or data from SQL Server. Let's set it up step by step

1. Allow to use Database Mail XPs

2. Turn on a DBMail system

3. Create SMTP-account, SMTP-profile and connect it together.

4. Check receiving of test email. I'll show to ways to do it:

First:

Second:

SQL Server Management Studio -> Object Explorer -> Management ->Database Mail. Click with a right mouse button - > choose "Send Test E- Mail" - > Enter you E-mail.