How to send email from SQL Server?

Does anyone here know of a way to send an Email using SQL Server? Has anyone seen code to do this? I found this today: http://forums.asp.net/t/1361259.aspx/1 ... Have you tried to send a test email using the Mail Profile you created? In SSMS, go to ...

social.technet.microsoft.com