SqlServer发送邮件

-- =============================================-- Author:<Author,SJL,Name>-- Create date: <Create Date,2015-11-23 10:27:00,>-- Description:<Description,发送邮件,>-- =============================================CREATE PROCEDURE [dbo].[proc_send_email](    @error_abstract varchar(100),-- 错误摘要(即简要描述错误信息)@error_msg varchar(4000)-- 错误详细信息)ASBEGINSET NOCOUNT ON;DECLARE @emailBody VARCHAR(4000); BEGIN SELECT @emailBody='错误摘要：' + @error_abstract + '<br/>错误信息：'+@error_msg + '<br/>时     间：'+ convert(varchar(20),getdate(),20) ; Exec msdb.dbo.sp_send_dbmail @profile_name='SQLMailConfig', @recipients='[e-mail];',<span style="font-family: Arial, Helvetica, sans-serif;">--多个用分号分割</span>@subject=@error_abstract, @body=@emailBody,@body_format='HTML'ENDEND