Downloads

A trial version can be downloaded from the links below. The trial can be activated in place by purchasing a licence key. If you would like to test drive the new SQLCLR version then please email support@thorpesoftware.com.

  • 32 bit Extended Stored Procedure for 32 bit SQL Server 7.0 onwards Download file
  • 64 bit Extended Stored Procedure for 64 bit SQL Server 7.0 onwards Download file

Installation Instructions (32bit)

xp_SMTPSendMail80 is a single dll. smtpsendmail80.dll should be copied into a directory on the SQL Server machine. The following command is issued from SQL Server Management Studio or any SQL Window:

use master
go
sp_addextendedproc 'xp_SMTPSendMail80', '<filepath>\smtpsendmail80.dll'
go

Please note that the extended stored procedure name is case sensitive and must be input as shown. Also please note the System Requirements below.

Installation Instructions (64bit)

xp_SMTPSendMail80 is a single dll. smtpsendmail80.dll should be copied into a directory on the SQL Server machine. The following command is issued from SQL Server Management Studio or any SQL Window:

use master
go
sp_addextendedproc 'xp_SMTPSendMail80', '<filepath>\smtpsendmail80_64.dll'
go

Please note that the extended stored procedure name is case sensitive and must be input as shown. Also please note the System Requirements below.

System Requirements

The Microsoft C++ 2008 Redistributable Package needs to be already installed. To test whether it is installed run xp_SMTPSendMail80 with no parameters. It should display the list of available parameters arranged as a calling template. If it fails with a "Cannot load dll" message then the runtime needs to be installed. This can be installed from the Microsoft website as detailed below.

  • Load 32 bit version from here
  • Load 64 bit version from here

Documentation