Send SMTP mail directly from any version of Microsoft SQL Server

Version 3.1 Released - Now includes support for plain text SMTP Authenication

ThorpeSoftware released the xp_SMTPSendMail extended stored proc in 2002 to send emails directly from SQL Server. It has been enhanced and adapted supporting all versions of SQL Server from 4.21a to 2008. It is now available as a 32 bit extended procedure, 64 bit extended stored procedure or a SQLCLR hosted assembly. The calling convention is compatible across all versions making it possible to have the same code running on multiple versions of SQL Server.

Produce formatted emails from multiple queries direct from SQL Server like the one illustrated below. Other examples with the code are given here.