Is it possible to send encrypted email using the Database Mail component of SQL Server? I'm looking into adding encryption support to a system that currently uses Database Mail for sending out emails. S/MIME is preferable, but PGP is also OK.
If this isn't possible, I guess I will need to alter the architecture and add an extra component that handles sending emails (either an entirely separate program or an SQLCLR stored procedure). Do you have a recommendation for a C#/.NET library for this purpose?