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) '[email protected]', -- e-mail 'to' varchar(50) '[email protected]', -- 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.
VERSION HISTORY
- Version 1.3 posted on 2008-09-30
Program Details
- Category: Business > Databases & Tools
- Publisher: Fantom Laboratory Ltd
- License: Free Trial
- Price: $19.00
- Version: 1.3
- Platform: windows
EULA
Please note that by using "Sndmail.DLL" you are accepting the conditions listed below. IMPORTANT - READ CAREFULLY "Sndmail.DLL" Software License Agreement "Sndmail.DLL" is a shareware program. Anyone may use this Software as trial version. If you wish to continue to use this Software, you MUST purchase and download full version. Once purchased, you are granted a non-exclusive license to use the "Sndmail.DLL" software. This license enables the use of the "Sndmail.DLL" for the following purposes: Use the "Sndmail.DLL" on one computer (workstation/server) in your organization or your home; Distribute the "Sndmail.DLL" as part of your own software; It is not allowed to distribute the "Sndmail.DLL" alone; It is not allowed to modify the "Sndmail.DLL". All copyrights to "Sndmail.DLL" are exclusively owned by Fantom Laboratory Ltd. (www.fantom-soft.com) Fantom Laboratory Ltd. reserves the right to change the price for the program without prior notice. Installing and using "Sndmail.DLL" signifies acceptance of these terms and conditions of the license. Disclaimer of Warranty THIS SOFTWARE IS DISTRIBUTED "AS IS". NO WARRANTY OF ANY KIND IS EXPRESSED OR IMPLIED. YOU USE IT AT YOUR OWN RISK. YOU ASSUME RESPONSIBILITY FOR SELECTING THE SOFTWARE TO ACHIEVE YOUR INTENDED RESULTS, AND FOR THE INSTALLATION OF, USE OF, AND RESULTS OBTAINED FROM THE SOFTWARE. THE AUTHOR WILL NOT BE LIABLE FOR DATA LOSS, DAMAGES, LOSS OF PROFITS OR ANY OTHER KIND OF LOSS WHILE USING OR MISUSING THIS SOFTWARE AND(OR) ANY KIND OF DATA DERIVED.