Back to OIM Explorer

dbo.QBM_TDAssembly_DialogColumn

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DialogColumn. Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 2; Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 2; Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 2; Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 2

Source: sandbox-db sys.sql_modules

Source size: 2.150 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 2
  • Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 2
  • Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 2
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 2
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 2
  • Single DBQueue insert -> QBM-K-CommonMakeRITriggerPre / QBM_ZRITriggerPrepare at line 2
  • 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
  • Single DBQueue insert -> QBM-K-CommonMakeRITriggerPre / QBM_ZRITriggerPrepare at line 3
  • Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 8
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 8
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 8
  • Single DBQueue insert -> QBM-K-CommonMakeRITriggerPre / QBM_ZRITriggerPrepare at line 8
  • Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 12
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 12
  • Single DBQueue insert -> QBM-K-CommonMakeRITriggerPre / QBM_ZRITriggerPrepare at line 12
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 13
  • Single DBQueue insert -> QBM-K-CommonMakeRITriggerPre / QBM_ZRITriggerPrepare at line 13
  • References QBM_PDBQueueInsert_Single
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: DialogColumn

Typed Edges

  • queues DBQueue task QBM_ZScriptAssemblyReset at line 2 Single DBQueue insert -> QBM-K-ScriptAssemblyReset / QBM_ZScriptAssemblyReset at line 2
  • queues DBQueue task QBM_ZViewBuildAll at line 2 Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 2
  • queues DBQueue task QBM_ZTriggerWatchCreate at line 2 Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 2
  • queues DBQueue task QBM_ZRITriggerCreate at line 2 Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 2
  • queues DBQueue task QBM_ZRITriggerPrepare at line 2 Single DBQueue insert -> QBM-K-CommonMakeRITriggerPre / QBM_ZRITriggerPrepare at line 2
  • 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_ZRITriggerPrepare at line 3 Single DBQueue insert -> QBM-K-CommonMakeRITriggerPre / QBM_ZRITriggerPrepare at line 3
  • queues DBQueue task QBM_ZViewBuildAll at line 8 Bulk DBQueue insert -> QBM-K-CommonRebuildView / QBM_ZViewBuildAll at line 8
  • queues DBQueue task QBM_ZTriggerWatchCreate at line 8 Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 8
  • queues DBQueue task QBM_ZRITriggerCreate at line 8 Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 8
  • queues DBQueue task QBM_ZRITriggerPrepare at line 8 Single DBQueue insert -> QBM-K-CommonMakeRITriggerPre / QBM_ZRITriggerPrepare at line 8
  • queues DBQueue task QBM_ZTriggerWatchCreate at line 12 Bulk DBQueue insert -> QBM-K-CommonMakeWatchtrigger / QBM_ZTriggerWatchCreate at line 12
  • queues DBQueue task QBM_ZRITriggerCreate at line 12 Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 12
  • queues DBQueue task QBM_ZRITriggerPrepare at line 12 Single DBQueue insert -> QBM-K-CommonMakeRITriggerPre / QBM_ZRITriggerPrepare at line 12
  • queues DBQueue task QBM_ZRITriggerCreate at line 13 Bulk DBQueue insert -> QBM-K-CommonMakeRITrigger / QBM_ZRITriggerCreate at line 13
  • queues DBQueue task QBM_ZRITriggerPrepare at line 13 Single DBQueue insert -> QBM-K-CommonMakeRITriggerPre / QBM_ZRITriggerPrepare at line 13
  • trigger on table DialogColumn Trigger parent table: DialogColumn
  • 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

SQL103 lines
1CREATE trigger QBM_TDAssembly_DialogColumn2  ON DialogColumn 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    EXEC QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset',14    'Tmpl',15    '#',16      @GenProcID17    EXEC QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset',18    'TypedWrappers',19    '#',20      @GenProcID21    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw22    INSERT INTO @DBQueueElements_01(object,23    subobject,24    genprocid)25    SELECT26      x.uid,27      NULL,28      @GenProcID29    FROM(30    SELECT d.UID_DialogTable AS UID31    FROM deleted d32    UNION33    SELECT t.UID_DialogTableBase34    FROM DialogTable t35    JOIN deleted d36      ON d.UID_DialogTable = t.UID_DialogTable37    WHERE38      t.UID_DialogTableBase > ' '39    UNION40    SELECT t.UID_DialogTable41    FROM DialogTable t42    JOIN deleted d43      ON d.UID_DialogTable = t.UID_DialogTableBase44    UNION45    SELECT t.UID_DialogTableunion46    FROM DialogTable t47    JOIN deleted d48      ON d.UID_DialogTable = t.UID_DialogTable49    WHERE50      t.UID_DialogTableunion > ' ') AS x51    WHERE52      x.uid IN(53    SELECT UID_DialogTable54    FROM dialogtable55    WHERE56      tabletype IN('V', 'P'))57    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildView',58      @DBQueueElements_0159    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw60    INSERT INTO @DBQueueElements_02(object,61    subobject,62    genprocid)63    SELECT64      dbo.QBM_FGITableName(x.uid),65      NULL,66      @GenProcID67    FROM(68    SELECT d.UID_DialogTable AS UID69    FROM deleted d70    UNION71    SELECT t.UID_DialogTable72    FROM dialogtable t73    JOIN deleted c74      ON c.UID_DialogTable = t.UID_DialogTableUnion75    UNION76    SELECT t.UID_DialogTableBase77    FROM DialogTable t78    JOIN deleted d79      ON d.UID_DialogTable = t.UID_DialogTable80    WHERE81      t.UID_DialogTableBase > ' '82    UNION83    SELECT t.UID_DialogTable84    FROM DialogTable t85    JOIN deleted d86      ON d.UID_DialogTable = t.UID_DialogTableBase) AS x87    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeWatchtrigger',88      @DBQueueElements_0289    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITrigger',90      @DBQueueElements_0291    EXEC QBM_PDBQueueInsert_Single 'QBM-K-CommonMakeRITriggerPre',92    '',93    '',94      @GenProcID95  END TRY96  BEGIN CATCH97    EXEC QBM_PSessionErrorAdd DEFAULT98    RAISERROR('',99    18,100    1)101      WITH NOWAIT102  END CATCH103END
Open raw exported source
SQL ยท Raw15 lines
1  create   trigger QBM_TDAssembly_DialogColumn on DialogColumn  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: exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset', 'Tmpl', '#'3, @GenProcID  exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset', 'TypedWrappers', '#', @GenProcID  declare @DBQueueElements_01 QBM_YDBQueueRaw4 insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select d.UID_DialogTable as UID from deleted d union5 select t.UID_DialogTableBase from DialogTable t join deleted d on d.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableBase > ' ' union select6 t.UID_DialogTable from DialogTable t join deleted d on d.UID_DialogTable = t.UID_DialogTableBase union select t.UID_DialogTableunion from DialogTable 7t join deleted d on d.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableunion > ' ' ) as x  where x.uid  in (select UID_DialogTable from dialogtable8 where tabletype in ('V', 'P') ) exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildView', @DBQueueElements_01  declare @DBQueueElements_02 QBM_YDBQueueRaw9 insert into @DBQueueElements_02 (object, subobject, genprocid) select dbo.QBM_FGITableName(x.uid), null, @GenProcID from (select  d.UID_DialogTable as10 UID from deleted d union  select t.UID_DialogTable from dialogtable t join deleted c on c.UID_DialogTable = t.UID_DialogTableUnion  union select t.UID_DialogTableBase11 from DialogTable t join deleted d on d.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableBase > ' ' union select t.UID_DialogTable from DialogTable12 t join deleted d on d.UID_DialogTable = t.UID_DialogTableBase ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeWatchtrigger', @DBQueueElements_02 13  exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITrigger' , @DBQueueElements_02   exec QBM_PDBQueueInsert_Single 'QBM-K-CommonMakeRITriggerPre', '', ''14, @GenProcID END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 15