Forum Replies Created

Viewing 2 posts - 16 through 17 (of 17 total)

  • RE: try - catch --- doesn't work well --- Please help !!!

    You would need to embed the logic within the procedure being called, not the procedure calling the procedure. So in the example you gave, each database's version of procedure...

  • RE: try - catch --- doesn't work well --- Please help !!!

    If the stored procedures being called include metadata from INFORMATION_SCHEMA.ROUTINES in the RAISERROR, they should return the desired results.

    CREATE PROCEDURE usp_ErrorTest

    AS

    DECLARE @ProcName nvarchar(128);

    DECLARE @RoutineCatalog varchar(128)

    DECLARE @RoutineSchema varchar(128)

    SET @ProcName = OBJECT_NAME(@@PROCID);

    select...

Viewing 2 posts - 16 through 17 (of 17 total)