Win32 DLL.
Contains Microsoft(c) SQL Server extended stored procedure - xp_sndmail.
xp_sndmail - is alternative to xp_sendmail unlike which allows to send e-mail messages by means of only SMTP protocol, without use MAPI and MS Outlook.
xp_rcvmail - is alternative to xp_readmail , allows to read e-mail messages by POP3 protocol
Copy Sndmail.dll to the directory containing the standard SQL Server DLL files (C:\Program Files\Microsoft SQL Server\Mssql\Binn by default).
use master
go
sp_addextendedproc 'xp_sndmail', 'sndmail.dll'
go
Example.
declare @error int
exec @error=master..xp_sndmail
'192.168.1.1', -- IP-address of SMTP-server varchar(15)
'192.168.1.10', -- IP-address of local PC varchar(15)
'bob@company.com', -- e-mail 'to' varchar(50)
'sql@company.com', -- e-mail 'from' varchar(50)
'Alarm', -- subject varchar(100)
'Message' -- message body varchar(8000)
select @error
Variable @error will contain an error code, 0 - completed successfully.