I am fairly new to MS SQL and an wondering if the following is possible;
Step 1 - person fills out a form on our website and submits it to our SQL DB via a stored procedure
Step 2 - the stored procedure inserts some of this information into a DB table and sends some of the information via the inbuild DBMail in an email.
Firstly, is this possible
Sencondly, is there a way of encrypting this email before it is sent
Email Functionality from SQl 2005
saspath
"Firstly, is this possible "
Sure, look in the BOl for sp_send_dbmail for more information.
"Sencondly, is there a way of encrypting this email before it is sent "
What do you mean by that AFAIK S/MIME or another technique isn’t available for sending mails via SQL Server.
HTH, jens Suessmeyer.
---
http://www.sqlserver2005.de
---