Back to OIM Explorer

dbo.QBM_TDAssembly_DialogTable

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DialogTable. Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 3; Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 3; Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 3; Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 3

Source: sandbox-db sys.sql_modules

Source size: 1.699 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-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 3
  • Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 3
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 3
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 3
  • Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 3
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 3
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 6
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 6
  • Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 6
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 6
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 7
  • Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 7
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 7
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 10
  • References QBM_PDBQueueInsert_Single
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: DialogTable

Typed Edges

  • queues DBQueue task QBM_ZScriptAssemblyReset at line 3 Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 3
  • queues DBQueue task QBM_ZViewBuildR at line 3 Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 3
  • queues DBQueue task QBM_ZViewBuildU at line 3 Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 3
  • queues DBQueue task QBM_ZViewBuildAll at line 3 Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 3
  • queues DBQueue task QBM_ZTriggerWatchCreate at line 3 Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 3
  • queues DBQueue task QBM_ZViewBuildR at line 6 Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 6
  • queues DBQueue task QBM_ZViewBuildU at line 6 Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 6
  • queues DBQueue task QBM_ZViewBuildAll at line 6 Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 6
  • queues DBQueue task QBM_ZTriggerWatchCreate at line 6 Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 6
  • queues DBQueue task QBM_ZViewBuildU at line 7 Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 7
  • queues DBQueue task QBM_ZViewBuildAll at line 7 Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 7
  • queues DBQueue task QBM_ZTriggerWatchCreate at line 7 Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 7
  • queues DBQueue task QBM_ZTriggerWatchCreate at line 10 Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 10
  • trigger on table DialogTable Trigger parent table: DialogTable
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_FGITableName 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_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL86 lines
1CREATE trigger QBM_TDAssembly_DialogTable2  ON DialogTable FOR3DELETE NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM deleted)11    GOTO start12    RETURN start:13    IF EXISTS(14      SELECT TOP 1 115      FROM deleted i16      WHERE17        i.TableType IN('T', 'V'))18    BEGIN19      EXEC QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset',20      'Table',21      '#',22        @GenProcID23    END24    EXEC QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset',25    'TypedWrappers',26    '#',27      @GenProcID28    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw29    INSERT INTO @DBQueueElements_01(object,30    subobject,31    genprocid)32    SELECT33      x.uid,34      NULL,35      @GenProcID36    FROM(37    SELECT d.UID_DialogTable AS UID38    FROM deleted d39    UNION40    SELECT d.UID_DialogTableBase41    FROM deleted d42    WHERE43      d.UID_DialogTableBase > ' '44    UNION45    SELECT d.UID_DialogTableUnion46    FROM deleted d47    WHERE48      d.UID_DialogTableUnion > ' ') AS x49    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewR',50      @DBQueueElements_0151    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewU',52      @DBQueueElements_0153    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildView',54      @DBQueueElements_0155    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw56    INSERT INTO @DBQueueElements_02(object,57    subobject,58    genprocid)59    SELECT60      dbo.QBM_FGITableName(x.uid),61      NULL,62      @GenProcID63    FROM(64    SELECT d.UID_DialogTable AS UID65    FROM deleted d66    UNION67    SELECT d.UID_DialogTableBase68    FROM deleted d69    WHERE70      d.UID_DialogTableBase > ' '71    UNION72    SELECT d.UID_DialogTableUnion73    FROM deleted d74    WHERE75      d.UID_DialogTableUnion > ' ') AS x76    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeWatchtrigger',77      @DBQueueElements_0278  END TRY79  BEGIN CATCH80    EXEC QBM_PSessionErrorAdd DEFAULT81    RAISERROR('',82    18,83    1)84      WITH NOWAIT85  END CATCH86END
Open raw exported source
SQL ยท Raw12 lines
1 create   trigger QBM_TDAssembly_DialogTable on DialogTable  for Delete not for Replication as begin declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext2('') BEGIN TRY if exists (select top 1 1 from deleted) goto start return start: if exists (select top 1 1 from deleted i where i.TableType in ('T', 'V'3) ) begin exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset', 'Table', '#', @GenProcID  end exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset'4, 'TypedWrappers', '#', @GenProcID  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid5, null, @GenProcID from (select d.UID_DialogTable as UID from deleted d union select d.UID_DialogTableBase from deleted d where d.UID_DialogTableBase >6 ' ' union select d.UID_DialogTableUnion from deleted d where d.UID_DialogTableUnion > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewR'7, @DBQueueElements_01 exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewU', @DBQueueElements_01 exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildView'8, @DBQueueElements_01  declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select dbo.QBM_FGITableName9(x.uid), null, @GenProcID from (select d.UID_DialogTable as UID from deleted d union select d.UID_DialogTableBase from deleted d where d.UID_DialogTableBase10 > ' ' union select d.UID_DialogTableUnion from deleted d where d.UID_DialogTableUnion > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeWatchtrigger'11, @DBQueueElements_02  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 12