Embed SQL Management Studio

I'm trying to embed SQL Management Studio in an installation package and although the SQL website says that it CAN be embedded there are no instructions on HOW to embed it. I can only find instructions on embedding SQL Express edition. If anyone can help with this I'd appreciate it!

Karen

You can NOT distribute SQL Server Management Studio with SQL Server Express. That would be a license violation. And I believe that because of the EULA, Management Studio Express requires the end user to install the tool.

sql

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