Configure and send E-Mail from SQL Server
In this article we will discuss how to configure and send emails from SQL server 2008.
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
Next step setup database mail.
Now you have to add profile name and profile description and click Add
Now you have to enter account details and click OK.
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