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;