Sndmail.DLL

Contains MS SQL Server extended stored procedure - xp_sndmail, xp_rcvmail
Download

Sndmail.DLL Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Free to try
  • Price:
  • $23.00
  • Publisher Name:
  • Fantom Laboratory Ltd
  • Publisher web site:
  • Operating Systems:
  • Windows
  • File Size:
  • 3.61K

Sndmail.DLL Tags


Sndmail.DLL Description

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 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.


Sndmail.DLL Related Software