Back to OIM Explorer

dbo.QBM_ZTriggerWatchCreate_S

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.034 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.QBM_PDBQueueCurrentResetNGen source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PTableLockEscalationSet source text reference
  • references source dbo.QBM_PTriggerWatchCreate source text reference
  • references source dbo.QBM_ZTriggerWatchCreate source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL53 lines
1CREATE PROCEDURE QBM_ZTriggerWatchCreate_S(2  @SlotNumber int,3  @TableName varchar(38),4  @Dummy varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @TriggerName varchar(30)10  DECLARE @ResetMessage nvarchar(4000)11  SET XACT_ABORT OFF12  BEGIN TRY13    BEGIN TRY14      SELECT15        @TriggerName = dbo.QBM_FGICodeName('T4',16        rtrim(@TableName))17      EXEC QBM_PTriggerWatchCreate @TableName,18      N 'INSERT',19        @TriggerName20      SELECT21        @TriggerName = dbo.QBM_FGICodeName('T5',22        rtrim(@TableName))23      EXEC QBM_PTriggerWatchCreate @TableName,24      N 'UPDATE',25        @TriggerName26      SELECT27        @TriggerName = dbo.QBM_FGICodeName('T6',28        rtrim(@TableName))29      EXEC QBM_PTriggerWatchCreate @TableName,30      N 'DELETE',31        @TriggerName32      EXEC QBM_PTableLockEscalationSet @TableName33    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 ยท Raw8 lines
1create   procedure QBM_ZTriggerWatchCreate_S (@SlotNumber int , @TableName varchar(38) , @Dummy varchar(38) , @GenProcID varchar(38) ) as begin 2declare @TriggerName varchar(30) declare @ResetMessage nvarchar(4000) SET XACT_ABORT OFF BEGIN TRY BEGIN TRY select @TriggerName = dbo.QBM_FGICodeName(3 'T4', rtrim(@TableName )) exec QBM_PTriggerWatchCreate @TableName , N'INSERT', @TriggerName select @TriggerName = dbo.QBM_FGICodeName( 'T5', rtrim(@TableName4 )) exec QBM_PTriggerWatchCreate @TableName , N'UPDATE', @TriggerName select @TriggerName = dbo.QBM_FGICodeName( 'T6', rtrim(@TableName )) exec QBM_PTriggerWatchCreate5 @TableName , N'DELETE', @TriggerName  exec QBM_PTableLockEscalationSet @TableName END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default select @ResetMessage6 = ERROR_MESSAGE() if @@TRANCOUNT > 0 begin rollback end  exec QBM_PDBQueueCurrentResetNGen @SlotNumber , @ResetMessage , @@PROCID END CATCH END TRY BEGIN7 CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 8