Back to OIM Explorer

dbo.QBM_TIAssembly_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-CommonRebuildView / QBM_ZViewBuildAll at line 3; Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 3

Source: sandbox-db sys.sql_modules

Source size: 2.266 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-CommonRebuildView / QBM_ZViewBuildAll at line 3
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 3
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate 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
  • Single DBQueue insert -> QBM-K-DBRoleDefFill / QBM_ZDBRoleDefFill at line 3
  • 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-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 6
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 6
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 6
  • Single DBQueue insert -> QBM-K-DBRoleDefFill / QBM_ZDBRoleDefFill at line 6
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 9
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 9
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 9
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 9
  • Single DBQueue insert -> QBM-K-DBRoleDefFill / QBM_ZDBRoleDefFill at line 9
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 11
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 11
  • Single DBQueue insert -> QBM-K-DBRoleDefFill / QBM_ZDBRoleDefFill at line 11
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 13
  • Single DBQueue insert -> QBM-K-DBRoleDefFill / QBM_ZDBRoleDefFill at line 13
  • Single DBQueue insert -> QBM-K-DBRoleDefFill / QBM_ZDBRoleDefFill at line 14
  • 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_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_ZRITriggerCreate at line 3 Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate 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_ZDBRoleDefFill at line 3 Single DBQueue insert -> QBM-K-DBRoleDefFill / QBM_ZDBRoleDefFill at line 3
  • 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_ZRITriggerCreate at line 6 Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 6
  • 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_ZDBRoleDefFill at line 6 Single DBQueue insert -> QBM-K-DBRoleDefFill / QBM_ZDBRoleDefFill at line 6
  • queues DBQueue task QBM_ZTriggerWatchCreate at line 9 Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 9
  • queues DBQueue task QBM_ZRITriggerCreate at line 9 Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 9
  • queues DBQueue task QBM_ZViewBuildR at line 9 Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 9
  • queues DBQueue task QBM_ZViewBuildU at line 9 Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 9
  • queues DBQueue task QBM_ZDBRoleDefFill at line 9 Single DBQueue insert -> QBM-K-DBRoleDefFill / QBM_ZDBRoleDefFill at line 9
  • queues DBQueue task QBM_ZViewBuildR at line 11 Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 11
  • queues DBQueue task QBM_ZViewBuildU at line 11 Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 11
  • queues DBQueue task QBM_ZDBRoleDefFill at line 11 Single DBQueue insert -> QBM-K-DBRoleDefFill / QBM_ZDBRoleDefFill at line 11
  • queues DBQueue task QBM_ZViewBuildU at line 13 Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 13
  • queues DBQueue task QBM_ZDBRoleDefFill at line 13 Single DBQueue insert -> QBM-K-DBRoleDefFill / QBM_ZDBRoleDefFill at line 13
  • queues DBQueue task QBM_ZDBRoleDefFill at line 14 Single DBQueue insert -> QBM-K-DBRoleDefFill / QBM_ZDBRoleDefFill at line 14
  • 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

SQL115 lines
1CREATE trigger QBM_TIAssembly_DialogTable2  ON DialogTable FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    RETURN start:13    IF EXISTS(14      SELECT TOP 1 115      FROM inserted 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 i.UID_DialogTable AS UID38    FROM inserted i39    UNION40    SELECT i.UID_DialogTableBase41    FROM inserted i42    WHERE43      i.UID_DialogTableBase > ' '44    UNION45    SELECT i.UID_DialogTableUnion46    FROM inserted i47    WHERE48      i.UID_DialogTableUnion > ' ') AS x49    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildView',50      @DBQueueElements_0151    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw52    INSERT INTO @DBQueueElements_02(object,53    subobject,54    genprocid)55    SELECT56      dbo.QBM_FGITableName(x.uid),57      NULL,58      @GenProcID59    FROM(60    SELECT i.UID_DialogTable AS UID61    FROM inserted i62    UNION63    SELECT t.UID_DialogTable64    FROM dialogtable t65    JOIN inserted c66      ON c.UID_DialogTable = t.UID_DialogTableUnion) AS x67    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeWatchtrigger',68      @DBQueueElements_0269    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITrigger',70      @DBQueueElements_0271    DECLARE @DBQueueElements_03 QBM_YDBQueueRaw72    INSERT INTO @DBQueueElements_03(object,73    subobject,74    genprocid)75    SELECT76      x.uid,77      NULL,78      @GenProcID79    FROM(80    SELECT i.UID_DialogTable AS UID81    FROM inserted i82    WHERE83      TableType = 'R') AS x84    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewR',85      @DBQueueElements_0386    DECLARE @DBQueueElements_04 QBM_YDBQueueRaw87    INSERT INTO @DBQueueElements_04(object,88    subobject,89    genprocid)90    SELECT91      x.uid,92      NULL,93      @GenProcID94    FROM(95    SELECT i.UID_DialogTable AS UID96    FROM inserted i97    WHERE98      TableType = 'U') AS x99    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewU',100      @DBQueueElements_04101    EXEC QBM_PDBQueueInsert_Single 'QBM-K-DBRoleDefFill',102    '',103    '',104      @GenProcID105  END TRY106  BEGIN CATCH107    EXEC QBM_PSessionErrorAdd DEFAULT108    RAISERROR('',109    18,110    1)111      WITH NOWAIT112  END CATCH113  ende:114  RETURN115END
Open raw exported source
SQL ยท Raw16 lines
1   create   trigger QBM_TIAssembly_DialogTable on DialogTable  for Insert not for Replication as begin declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext2('') BEGIN TRY if exists (select top 1 1 from inserted) goto start return start: if exists (select top 1 1 from inserted 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 i.UID_DialogTable as UID from inserted i union select i.UID_DialogTableBase from inserted i where i.UID_DialogTableBase6 > ' ' union select i.UID_DialogTableUnion from inserted i where i.UID_DialogTableUnion > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildView'7, @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select dbo.QBM_FGITableName8(x.uid), null, @GenProcID from (select i.UID_DialogTable as UID from inserted i  union select t.UID_DialogTable from dialogtable t join inserted c on c.UID_DialogTable9 = t.UID_DialogTableUnion  ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeWatchtrigger', @DBQueueElements_02 exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITrigger'10, @DBQueueElements_02  declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID11 from (select i.UID_DialogTable as UID from inserted i where TableType = 'R' ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewR', @DBQueueElements_0312  declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select13 i.UID_DialogTable as UID from inserted i where TableType = 'U' ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewU', @DBQueueElements_04  exec14 QBM_PDBQueueInsert_Single 'QBM-K-DBRoleDefFill', '', '', @GenProcID END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT15 END CATCH ende: return end 16