Configure and Send E-Mail From SQL Server

Here you can see how to configure and send mail from SQL Server.

Step 1: Open SQL Server then open Object Explorer then select "Management" -> "SQL Server Logs" then right-click "Database Mail" then click "Configure Database Mail".


                                                                                       Image 1


                                                                           Image 2
Click "Next >".


                                                                           Image 3
Click "Next >".


                                                                           Image 4

Step 2: Here enter a Profile Name and Description and click Add.


                                                                                 Image 5


                                                                                 Image 6


                                                                              Image 7


                                                                                 Image 8


                                                                              Image 9


                                                                           Image 10


                                                                           Image 11

Step 3: Now the profile and account have been created and we will configure the database mail using the following Stored Procedure.


                                                                                 Image 12

Step 4: Now using the following Stored Procedure we will send mail.


                                                                                 Image 13

Step 5: Now we can track the status of the mail.


                                                                               Image 14