How simple we can send Mail using SQL Server

Hi All ,

We can send email through SQL Server also,for this follow some simple steps.

Step 1:
          Open SQL Server Management Studio and then connect to server and go to  management tab in that right click on Database Mail then click on configure mail,then click on setup database mail then click on next.



Step 2:
           Now u can give profile name for the email and create new SMTP account , for that click on add and click on new account fill accordingly as shown in below image.

Step 3:
           Now manage profile Security and select u r's profile then click next and next and finsh.

Step 4:

           Now test the mail ,for that again right click on Database Mail and select Send Test E-Mail .and u will get email.

Thanks For Visiting Blog.