SQLCLR Version
 Introduction
Supports all parameters listed for the 32 and 64 bit version plus the additional ones listed below.
Versions
Compatible with SQL Server 2005 and greater.
Calling Convention
The following are either new parameters or changed parameters. The changed parameters are indicated in italics. Where parameters have changed the old syntax is automatically supported.
@excodepage
Accepts the whole code page string to be input such as 'x-mac-korean'. The original version only supported iso-8859 code pages. @codepage is still available for backwards compatibility.
@qrecipient
Accepts a query which runs against the local database. This query should return a resultset containing the recipient email address in the first column. E.g. select emailaddress from emailtable.
@qcc
as @qrecipient above but for the cc field.
@qbcc
as @qrecipient above but for the bcc field.
@address
now allows a list of SMTP servers to be given separated by a ; or a ,. The servers will be tried in the order listed.
@qaddress
accepts a query which runs against the local database. This query should return a resultset containing a list of SMTP servers. If @address is given as well, the servers in @address will be tried first followed by those in @qaddress.

Copyright© Panacea Communications Limited