Configure and send E-Mail from SQL Server

Introduction

To build high-trafficked scalable web applications, it is recommended not to stuck your email code in the application code. Instead, we can use SQL Server to send all messages and emails. In this article, we will see how to configure your SQL Server 2008 to send emails.

Step 1 :

First of all you need to start SQL Server Management Studio.

And right click on Database Mail and click Configure Database Mail.

Next step setup database mail.

Step 2



Now you have to add profile name and profile description and click Add

Step 3



Now you have to enter account details and click OK.

Step 4





Click Next



Click Next



Click Next and Finish





Now profile and account has been created well now time to configure database mail. To configure database mail first we have to enable database mail XPs parameter using sp_configure stored procedure.



Now time to send mail.

To track the mail status and log status execute this query.