You downloaded and tested our software?

Feel free to use e-mail support@fantom-soft.com to send us your comments, suggestions, and so on.

Every message gets consideration.

NEW!

H323 SoftSwitch

100 simultaneous calls. Very small size. Easy configuring. Flexible calls routing. Does not require gatekeeper.

It is low cost VoIP solution for office.

Sndmail.dll

v 1.1

Latest Release

27 Feb 2007

Download trial version

Sndmail.ZIP

~ 8Kb

$19.90

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

Add extended stored procedure function by Enterprise Manager or by commands

use master

go

sp_addextendedproc 'xp_sndmail', 'sndmail.dll'

go

Extended stored procedure added.

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.

If necessary to remove procedure xp_sndmail it is possible to use the following commands:

sp_dropextendedproc 'xp_sndmail'

go

and unloads DLL from memory

dbcc sndmail (free)

go

By a call of procedure without parameters (exec master..xp_sndmail) deduces a brief information on application.

More example.

Download SQL Scripts

Creation of stable send mail system

These SQL Scripts creates two stored procedures “sendmail” and “sendmailspl”, the table “_mailspool” and job “sendmail_spooler”.

Procedure “sendmail” has the same parameters, as MS SQL “xp_sendmail”.

It only an example of use “sndmail.dll”.

You can adapt and change SQL Scripts for the best use.

Restrictions trial versions

E-mail subject: “Trial version sndmail”