Hi All,

My Nested code is similar to the below code template

CREATE PROCEDURE usp_Proc1

AS

BEGIN TRY

BEGIN TRAN TRAN1

EXEC usp_Proc2

COMMIT TRAN TRAN1

END TRY

BEGIN CATCH

ROLLBACK TRAN TRAN1

END CATCH

---------------------------------------------------

CREATE PROCEDURE usp_Proc2

AS

BEGIN TRY

BEGIN TRAN TRAN2

EXEC usp_Proc3

COMMIT TRAN TRAN2

END TRY

BEGIN CATCH

ROLLBACK TRAN TRAN2

END CATCH

---------------------------------------------------

CREATE PROCEDURE usp_Proc3

AS

BEGIN TRY

BEGIN TRAN TRAN3

SOURCE CODE ----

COMMIT TRAN TRAN3

END TRY

BEGIN CATCH

ROLLBACK TRAN TRAN3

END CATCH

---------------------------------------------------

In summary, usp_Proc1 calls usp_Proc2 which in turn calls usp_Proc3.

I need to log all the error that might occur in above flow and also the source(proc_name) of error with description.

Regards,