Al's BrainDump

RSS

Navigation





Quick Search
»
Advanced Search »

PoweredBy
Create procedure to retrieve error information.

CREATE PROCEDURE usp_GetErrorInfo
AS
    SELECT
        ERROR_NUMBER() AS ErrorNumber,
        ERROR_SEVERITY() AS ErrorSeverity,
        ERROR_STATE() AS ErrorState,
        ERROR_PROCEDURE() AS ErrorProcedure,
        ERROR_LINE() AS ErrorLine,
        ERROR_MESSAGE() AS ErrorMessage;
GO

BEGIN TRY
    Generate divide-by-zero error.
    SELECT 1/0;
END TRY
BEGIN CATCH
    Execute error retrieval routine.
    EXECUTE usp_GetErrorInfo;
END CATCH;

ScrewTurn Wiki version 3.0.5.600. Some of the icons created by FamFamFam.