|
|
|
Download Now!
Free download 3KB
|
Version: |
1.0 |
| Homepage: |
Click here to visit |
| License: |
Shareware, $23.00 |
| Install Support: |
No Install Support |
| Language(s): |
English, Russian |
|
|
| |
Win32 DLL.
Contain Microsoft® SQL Server extended stored procedure – xp_sndmail.
xp_sndmail – is alternative 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 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.
|
|
| |
| OS: WinNT 4.x, Windows2000, Windows2003 |
| System Requirement: MS SQL 7.0-2000 |
|
Keywords: SQL, SQL Server, xp_sndmail, xp_sendmail, mail, extended stored procedure, SMTP, MAPI |
|
|
|