MSSQL数据库邮件系列二(SSMS和TSQL)

1.MSDN帮助文档

　　http://msdn.microsoft.com/zh-cn/library/ms190307.aspx

2.CNBLOGS帮助文档

　　http://kb.cnblogs.com/page/49354/

3.捕获数据库异常日志示例：

BEGIN TRY
    /*要执行的操作*/
    EXECUTE proc_GetREsumeInfo;
END TRY
BEGIN CATCH
    /*
    SELECT  ERROR_NUMBER() AS ,ErrorNumber,ERROR_SEVERITY() AS ,ErrorSeverity,ERROR_STATE() AS ErrorState, ERROR_PROCEDURE() AS ErrorProcedure,ERROR_MESSAGE() AS ErrorMessage,ERROR_LINE() AS ErrorLine;
　  */
    --失败时发送邮件提醒
    DECLARE @tableHTML VARCHAR(MAX) = '在 '+CONVERT(VARCHAR,GETDATE(),120)+' 执行存储过程 ['+ERROR_PROCEDURE()+'] 发生异常，请及时排除故障。<br />'+CHAR(10)+'错误原因描述如下：'+CHAR(10)+ERROR_MESSAGE()
    EXEC msdb.dbo.sp_send_dbmail @recipients='378743764@qq.com;',@subject='简历数据同步日志',@body=@tableHTML,
        @body_format='HTML';
END CATCH;