You can use the MS SQL Server extended stored procedure xp_smtp to send email messages. To send email messages using this procedure you do not need to create a mail profile for the user account that is used to start an instance of MS SQL Server.

Also it is not required to have any email clients installed. The extended procedure allows you to send HTML formatted messages.

Copy the xp_smtp.dll over to your SQL Server

Binn directory.

Add your new Extended Stored Procedure from a Visual Studio Data Project,

or using the SQL Server Enterprise Manager, or by executing the following

SQL command:

sp_addextendedproc 'xp_smtp', 'xp_smtp.DLL'

Limitations:

￭ Error will be raised at each call