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 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.
Database Convert
(Popularity: ) : 1) The Database Convert software is wizard-like; it's so easy, everyone can use it. You convert one database to the ... Access MySQL Import, Export & Convert
(Popularity: ) : This application will allow you to transfer tables to and from Access and MySQL databases. Importing and exporting can be ... Select to Excel
(Popularity: ) : This small Excel macro allows you to execute SQL commands on any ODBC data source directly in Excel and will ... Exportizer Pro
(Popularity: ) : Database tool for viewing, editing, filtering, copying, exporting tables of different formats (DB, DBF, MDB, XLS, GDB, IB, HTML, UDL, ... DBScribe for MySQL
(Popularity: ) : DBScribe is a free MySQL database documentation tool that creates precise technical documentation of every detail of a database schema ... ESF Database Convert
(Popularity: ) : If you are moving your data across different platforms or applications, then you know that it can’t be done by ... CDB Comparator
(Popularity: ) : CDB Comparator is a powerful easy-to-use ODBC based tool for comparison of heterogeneous databases, used by thousands DBAs, developers and ... NEROCODE MySQL Client
(Popularity: ) : GUI Client for MySQL Database Server administartion and development.
Some key features:
- Manage database
- Views
- Triggers
- ... SQL Balance for MySQL
(Popularity: ) : Database Administrators, rejoice! Business owners and IT managers, take a note! Now there is no need to compare and synchronize ... Benchmark Factory for Databases Freeware
(Popularity: ) : Benchmark Factory for Databases is a database performance and scalability testing tool for Oracle, SQL Server, DB2 UDB, Sybase ASE, ...
Software Library
) : 1) The Database Convert software is wizard-like; it's so easy, everyone can use it. You convert one database to the ...
