Breaking News: Grepper is joining You.com. Read the official announcement!

find error line in stored procedure

ekkamrit answered on May 11, 2023 Popularity 3/10 Helpfulness 1/10

answer find error line in stored procedure

find error line in stored procedure

Comment

CREATE OR ALTER PROCEDURE MyProc
AS
BEGIN
    -- Your code here
END;
GO

DECLARE @ErrorMessage NVARCHAR(4000);
DECLARE @ErrorSeverity INT;
DECLARE @ErrorState INT;

BEGIN TRY
    EXEC MyProc;
END TRY
BEGIN CATCH
    SET @ErrorMessage = ERROR_MESSAGE();
    SET @ErrorSeverity = ERROR_SEVERITY();
    SET @ErrorState = ERROR_STATE();

    RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState);
    SELECT ERROR_LINE() AS ErrorLine;
END CATCH
-- using this you can easily find the error line of the stored procedure.

Popularity 3/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: find line procedure sql

Link to this answer
Share Copy Link

Contributed on May 11 2023

ekkamrit

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

find error line in stored procedure

Contents

More Related Answers

find error line in stored procedure

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.