Code to send mail from a sql 2005 stored proc will look something like this: declare @body1 varchar ( 100 ) set @body1 = 'Server :' + @@servername + ' My First Database Email ' EXEC msdb . dbo . sp_send_dbmail @recipients = 'steve@4penny.net' , @subject = 'My Mail Test' , @body = @body1 , @profile_name...