Sndmail.DLL 1.3
SQL SERVER EXTENDED STORED PROCEDURE
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.
What is new in 1.3 software version? - Minor Update. What is expected in the future? Newly-made Sndmail.DLL 1.4 be downloaded from current page, we also looking forward to unconfirmed 1.5 release build. You may download sndmail.zip directly, estimated download time by Dialup or GPRS [~56 kbit/s] is 0:00:02. Just write the reviews of the Sndmail.DLL. System requirements are MS SQL 7.0-2000. Program has been scanned and verified by the several antivirus and anti-spyware applications and Sndmail.DLL found to be clean. The following languages are supported by Sndmail.DLL: English.
