download25.com
Your free TOP 25 download source!
Sndmail.DLL 1.0
Contains Microsoft® SQL Server extended stored procedure ? xp_sndmail
|
||||||||||||||||||||||
|
Review 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. |
||||||||||||||||||||||
|
Tags: Sql | Sql Server | Xp Sndmail | Xp Sendmail | Mail |
||||||||||||||||||||||
(sndmail.zip - 3.00 KB)
|
||||||||||||||||||||||
