Back to OIM Explorer

dbo.QBM_TDDialogTable

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DialogTable. Single DBQueue insert -> QBM-K-TableRevisionFill / QBM_ZTableRevisionFill at line 3; Bulk DBQueue insert -> QBM-K-MissingDisplayRightFill / QBM_ZMissingDisplayRightFill at line 3; Bulk DBQueue insert -> QBM-K-MissingDisplayRightFill / QBM_ZMissingDisplayRightFill at line 6; References QBM_PDBQueueInsert_Single

Source: sandbox-db sys.sql_modules

Source size: 1.034 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Single DBQueue insert -> QBM-K-TableRevisionFill / QBM_ZTableRevisionFill at line 3
  • Bulk DBQueue insert -> QBM-K-MissingDisplayRightFill / QBM_ZMissingDisplayRightFill at line 3
  • Bulk DBQueue insert -> QBM-K-MissingDisplayRightFill / QBM_ZMissingDisplayRightFill at line 6
  • References QBM_PDBQueueInsert_Single
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: DialogTable

Typed Edges

  • queues DBQueue task QBM_ZTableRevisionFill at line 3 Single DBQueue insert -> QBM-K-TableRevisionFill / QBM_ZTableRevisionFill at line 3
  • queues DBQueue task QBM_ZMissingDisplayRightFill at line 3 Bulk DBQueue insert -> QBM-K-MissingDisplayRightFill / QBM_ZMissingDisplayRightFill at line 3
  • queues DBQueue task QBM_ZMissingDisplayRightFill at line 6 Bulk DBQueue insert -> QBM-K-MissingDisplayRightFill / QBM_ZMissingDisplayRightFill at line 6
  • trigger on table DialogTable Trigger parent table: DialogTable
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PGUIDReplaceCustomizerFill source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL50 lines
1CREATE trigger QBM_TDDialogTable2  ON DialogTable FOR3DELETE NOT FOR Replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM deleted)10    GOTO start11    RETURN start:12    DECLARE @GenProcID varchar(38)13    SELECT @GenProcID = dbo.QBM_FGISessionContext('')14    EXEC QBM_PGUIDReplaceCustomizerFill15    EXEC QBM_PDBQueueInsert_Single 'QBM-K-TableRevisionFill',16    NULL,17    NULL,18      @GenProcID19    DECLARE @DBQueueElements_36836 QBM_YDBQueueRaw20    INSERT INTO @DBQueueElements_36836(Object,21    SubObject,22    GenProcID)23    SELECT24      x.uid,25      NULL,26      @GenProcID27    FROM(28    SELECT ra.UID_DialogTableParent AS uid29    FROM deleted t30    JOIN QBM_VQBMRelationALL ra31      ON t.UID_DialogTable = ra.UID_DialogTableChild32    UNION33    SELECT ra.UID_DialogTableChild34    FROM deleted t35    JOIN QBM_VQBMRelationALL ra36      ON t.UID_DialogTable = ra.UID_DialogTableParent37    UNION38    SELECT t.UID_DialogTable39    FROM deleted t) AS x40    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-MissingDisplayRightFill',41      @DBQueueElements_3683642  END TRY43  BEGIN CATCH44    EXEC QBM_PSessionErrorAdd DEFAULT45    RAISERROR('',46    18,47    1)48      WITH NOWAIT49  END CATCH50END
Open raw exported source
SQL ยท Raw8 lines
1  create   trigger QBM_TDDialogTable on DialogTable  for Delete not for Replication as begin  BEGIN TRY if exists (select top 1 1 from deleted) 2goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  exec QBM_PGUIDReplaceCustomizerFill    exec 3QBM_PDBQueueInsert_Single 'QBM-K-TableRevisionFill', null, null, @GenProcID  declare @DBQueueElements_36836 QBM_YDBQueueRaw insert into @DBQueueElements_368364(Object, SubObject, GenProcID) select x.uid, null, @GenProcID from ( select ra.UID_DialogTableParent as uid from deleted t join QBM_VQBMRelationALL ra 5on t.UID_DialogTable = ra.UID_DialogTableChild union select ra.UID_DialogTableChild from deleted t join QBM_VQBMRelationALL ra on t.UID_DialogTable = ra.UID_DialogTableParent6 union select t.UID_DialogTable from deleted t ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-MissingDisplayRightFill', @DBQueueElements_36836  END TRY BEGIN7 CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 8