In this article I explain how to configure and send 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 2Click "Next >". Image 3Click "Next >". Image 4Step 2: Here enter a Profile Name and Description and click Add. Image 5 Image 6 Image 7 Image 8 Image 9 Image 10 Image 11Step 3: Now the profile and account have been created and we will configure the database mail using the following Stored Procedure. Image 12Step 4: Now using the following Stored Procedure we will send mail. Image 13Step 5: Now we can track the status of the mail. Image 14
Functions in SQL Server: Practical Guide