Email Functionality from SQl 2005

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?

"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