Back to OIM Explorer

dbo.DPR_ZTriggerCreateMembership

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.121 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FGICodeName source text reference
  • references source dbo.DPR_PTriggerCreateMembership source text reference
  • references source dbo.QBM_PDBQueueCurrentResetNGen source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL53 lines
1CREATE PROCEDURE DPR_ZTriggerCreateMembership(2  @SlotNumber int,3  @TableName varchar(38),4  @Dummy varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @TriggerName varchar(30)10  DECLARE @Triggersuffix nvarchar(100) = object_name(@@procid)11  DECLARE @ResetMessage nvarchar(4000)12  SET XACT_ABORT OFF13  BEGIN TRY14    BEGIN TRY15      SELECT16        @TriggerName = dbo.QBM_FGICodeName('T4',17        rtrim(@TableName) + @Triggersuffix)18      EXEC DPR_PTriggerCreateMembership @TableName,19      N 'INSERT',20        @TriggerName21      SELECT22        @TriggerName = dbo.QBM_FGICodeName('T5',23        rtrim(@TableName) + @Triggersuffix)24      EXEC DPR_PTriggerCreateMembership @TableName,25      N 'UPDATE',26        @TriggerName27      SELECT28        @TriggerName = dbo.QBM_FGICodeName('T6',29        rtrim(@TableName) + @Triggersuffix)30      EXEC DPR_PTriggerCreateMembership @TableName,31      N 'DELETE',32        @TriggerName33    END TRY34    BEGIN CATCH35      EXEC QBM_PSessionErrorAdd DEFAULT36      SELECT @ResetMessage = ERROR_MESSAGE()37      IF @@TRANCOUNT > 038      BEGIN39        ROLLBACK40      END41      EXEC QBM_PDBQueueCurrentResetNGen @SlotNumber,42        @ResetMessage,43        @@PROCID44    END CATCH45  END TRY46  BEGIN CATCH47    EXEC QBM_PSessionErrorAdd DEFAULT48    RAISERROR('',49    18,50    1)51      WITH NOWAIT52  END CATCH53END
Open raw exported source
SQL ยท Raw9 lines
1  create   procedure DPR_ZTriggerCreateMembership (@SlotNumber int , @TableName varchar(38) , @Dummy varchar(38) , @GenProcID varchar(38) ) as begin2  declare @TriggerName varchar(30) declare @Triggersuffix nvarchar(100) = object_name(@@procid) declare @ResetMessage nvarchar(4000) SET XACT_ABORT OFF3 BEGIN TRY BEGIN TRY select @TriggerName = dbo.QBM_FGICodeName( 'T4', rtrim(@TableName )+ @Triggersuffix) exec DPR_PTriggerCreateMembership @TableName 4, N'INSERT', @TriggerName select @TriggerName = dbo.QBM_FGICodeName( 'T5', rtrim(@TableName )+ @Triggersuffix) exec DPR_PTriggerCreateMembership @TableName5 , N'UPDATE', @TriggerName select @TriggerName = dbo.QBM_FGICodeName( 'T6', rtrim(@TableName )+ @Triggersuffix) exec DPR_PTriggerCreateMembership @TableName6 , N'DELETE', @TriggerName END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default select @ResetMessage = ERROR_MESSAGE() if @@TRANCOUNT > 0 begin rollback7 end  exec QBM_PDBQueueCurrentResetNGen @SlotNumber , @ResetMessage , @@PROCID END CATCH END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR8 ('', 18, 1) WITH NOWAIT END CATCH end 9