Contains MS SQL Server extended stored procedure - xp_sndmail, xp_rcvmail
Editor: 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 FilesMicrosoft SQL ServerMssqlBinn 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. you can free download Sndmail.DLL 1.3 now.