SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DROP PROC IF EXISTS firstproc;
DROP PROC IF EXISTS secondproc;
DROP TABLE IF EXISTS errortable;
DROP TABLE IF EXISTS mytable;

CREATE TABLE mytable (
    A DECIMAL
    ,B DECIMAL
    )

INSERT INTO mytable
VALUES (
    1
    ,1
    )
    ,(
    1
    ,0
    )

2 rows affected

CREATE TABLE ErrorTable
(procname NVARCHAR(255));

CREATE PROCEDURE [dbo].[FirstProc]
AS
BEGIN
    BEGIN TRY
        SELECT A / B
        FROM mytable;
    END TRY

    BEGIN CATCH
      INSERT Errortable VALUES (OBJECT_NAME(@@PROCID));
	  THROW;
    END CATCH
END
CREATE PROCEDURE [dbo].[SecondProc]
AS
BEGIN
    BEGIN TRY
            CREATE TABLE #mytable
            (C DECIMAL  )

        INSERT INTO #mytable
        EXEC FirstProc
    END TRY

    BEGIN CATCH
      INSERT Errortable VALUES (OBJECT_NAME(@@PROCID));
	  THROW;
    END CATCH
END

EXEC secondproc;


Msg 8134 Level 16 State 1 Line 6
Divide by zero error encountered.

SELECT * FROM errortable


procname


SecondProc


DROP PROC IF EXISTS firstproc;
DROP PROC IF EXISTS secondproc;
DROP TABLE IF EXISTS mytable;
DROP TABLE IF EXISTS errortable;
CREATE TABLE mytable (
    A DECIMAL
    ,B DECIMAL
    )

INSERT INTO mytable
VALUES (
    1
    ,1
    )
    ,(
    1
    ,0
    )
2 rows affected

CREATE TABLE ErrorTable
(procname NVARCHAR(255));
CREATE PROCEDURE [dbo].[FirstProc]
AS
BEGIN
    BEGIN TRY
        SELECT A / B
        FROM mytable;
    END TRY

    BEGIN CATCH
      INSERT Errortable VALUES (OBJECT_NAME(@@PROCID));
	  THROW;
    END CATCH
END

CREATE PROCEDURE [dbo].[SecondProc]
AS
BEGIN
    BEGIN TRY
            CREATE TABLE #mytable
            (C DECIMAL  )

        --INSERT INTO #mytable
        EXEC FirstProc
    END TRY

    BEGIN CATCH
      INSERT Errortable VALUES (OBJECT_NAME(@@PROCID));
	  THROW;
    END CATCH
END

EXEC secondproc;




(No column name)


1.0000000000000000000


Msg 8134 Level 16 State 1 Line 6
Divide by zero error encountered.

SELECT * FROM errortable;


procname


FirstProc

SecondProc