|
|
|
|
|
|
|
|
|
|
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 mastergosp_addextendedproc 'xp_sndmail', 'sndmail.dll'goExample.declare @error intexec @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 @errorVariable @error will contain an error code, 0 completed successfully.
|
|
|
|
|
Related keywords:
sql, sql server, xp sndmail, xp sendmail, mail, extended stored procedure, smtp, mapi,
|
|
|
|
|
|
|
|
|
|
