Sql Server : Send Email

I want to use SQL Server to send email and found two possible way from the internet: Using AOSMTP.Mail Create PROCEDURE [dbo].[RC_SendEmail] @ServerAddr varchar(80), @FromAddr

Solution 1:

Forget that, use the send email capabilities built-in on SQL Server. It doesn't get any easier.

Once you configure it through the wizard, you can simply do this inside your procs, as shown in the tutorial linked:

USE msdb
GO
EXEC sp_send_dbmail @profile_name='PinalProfile',
@recipients='test@Example.com',
@subject='Test message',
@body='This is the body of the test message.'