SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE PROCEDURE DivZero
AS
BEGIN
	BEGIN TRY
		SELECT 1/0
	END TRY
	BEGIN CATCH
		THROW;
	END CATCH
END
CREATE PROCEDURE CallerProc
AS
BEGIN
	DECLARE @PrintMsg VARCHAR(MAX)
	
	BEGIN TRY
		SELECT @PrintMsg = 'Calling procedure name: ' + OBJECT_NAME(@@PROCID)
		
		EXEC DivZero
	END TRY
	BEGIN CATCH

		SELECT @PrintMsg = @PrintMsg + CHAR(10) + 'Error in Procedure: ' + CAST(ERROR_PROCEDURE() AS VARCHAR(100)) + ' at line ' + CAST(ERROR_LINE() AS VARCHAR(100))

		;THROW 50000, @PrintMsg, 1
	END CATCH
END
EXEC CallerProc


(No column name)


Msg 50000 Level 16 State 1 Line 15
Calling procedure name: CallerProc
Error in Procedure: DivZero at line 5