/*創(chuàng)建錯誤日志記錄存儲過程*/ CREATE PROCEDURE InsErrorLog AS BEGIN INSERT INTO ErrorLog SELECT ERROR_NUMBER() AS ErrNum, ERROR_SEVERITY()AS ErrSev, ERROR_STATE() AS ErrState, ERROR_PROCEDURE() AS ErrProc, ERROR_LINE()AS ErrLine, ERROR_MESSAGE()AS ErrMsg END 3、在存儲過程中使用BEGIN TRY,并捕捉錯誤保存：
CREATE PROCEDURE GetErrorTest AS BEGIN TRY /*在這里填寫存儲過程的內容*/ *** END TRY BEGIN CATCH EXEC InsErrorLog --調用 InsErrorLog 存儲過程,保存錯誤日志 END CATCH
