Sndmail.DLL 1.0

Shareware Author : Fantom Laboratory Ltd

OS : WinNT 4.x,Windows2000,Windows2003

Size : 3 kBytes

Price : $23.00 -Get the Full Version

License : Shareware

Added date : 14. October 2006

Release date : 17. August 2006

Download link: Download here

Publisher web: Visit Website

Software description :

Win32 DLL.
Contains Microsoft® 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.
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.

 Others shareware software in category

 More of shareware by this publisher