dbo.QBM_TDDialogColumn
Database TriggerSQL_TRIGGERSandbox DB
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
- Bulk DBQueue insert -> QBM-K-MissingDisplayRightFill / QBM_ZMissingDisplayRightFill at line 5
- Bulk DBQueue insert -> QBM-K-IndexCreateGenerated / QBM_ZIndexCreateGenerated at line 5
- Bulk DBQueue insert -> QBM-K-IndexCreateGenerated / QBM_ZIndexCreateGenerated at line 7
- References QBM_PDBQueueInsert_Bulk
- Trigger parent table: DialogColumn
Typed Edges
- queues DBQueue task QBM_ZMissingDisplayRightFill at line 5 Bulk DBQueue insert -> QBM-K-MissingDisplayRightFill / QBM_ZMissingDisplayRightFill at line 5
- queues DBQueue task QBM_ZIndexCreateGenerated at line 5 Bulk DBQueue insert -> QBM-K-IndexCreateGenerated / QBM_ZIndexCreateGenerated at line 5
- queues DBQueue task QBM_ZIndexCreateGenerated at line 7 Bulk DBQueue insert -> QBM-K-IndexCreateGenerated / QBM_ZIndexCreateGenerated at line 7
- trigger on table DialogColumn Trigger parent table: DialogColumn
- references source dbo.QBM_FGISessionContext source text reference
- references source dbo.QBM_PDBQueueInsert_Bulk source text reference
- references source dbo.QBM_PSessionErrorAdd source text reference
Complete Source
1CREATE trigger QBM_TDDialogColumn2 ON DialogColumn 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) = dbo.QBM_FGISessionContext('')13 DECLARE @DBQueueElements_36836 QBM_YDBQueueRaw14 INSERT INTO @DBQueueElements_36836(Object,15 SubObject,16 GenProcID)17 SELECT18 x.uid,19 NULL,20 @GenProcID21 FROM(22 SELECT ra.UID_DialogTableParent AS uid23 FROM deleted t24 JOIN QBM_VQBMRelationALL ra25 ON t.UID_DialogTable = ra.UID_DialogTableChild26 UNION27 SELECT ra.UID_DialogTableChild28 FROM deleted t29 JOIN QBM_VQBMRelationALL ra30 ON t.UID_DialogTable = ra.UID_DialogTableParent31 UNION32 SELECT t.UID_DialogTable33 FROM deleted t) AS x34 EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-MissingDisplayRightFill',35 @DBQueueElements_3683636 DECLARE @DBQueueElements_478459 QBM_YDBQueueRaw37 INSERT INTO @DBQueueElements_478459(object,38 subobject,39 genprocid)40 SELECT41 x.uid,42 NULL,43 @GenProcID44 FROM(45 SELECT46 DISTINCT t.TableName AS UID47 FROM deleted d48 JOIN DialogTable t49 ON d.UID_DialogTable = t.UID_DialogTable) AS x50 EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-IndexCreateGenerated',51 @DBQueueElements_47845952 END TRY53 BEGIN CATCH54 EXEC QBM_PSessionErrorAdd DEFAULT55 RAISERROR('',56 18,57 1)58 WITH NOWAIT59 END CATCH60ENDOpen raw exported source
1 create trigger QBM_TDDialogColumn on DialogColumn for Delete not for Replication as begin BEGIN TRY if exists (select top 1 1 from deleted2) goto start return start: declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext('') declare @DBQueueElements_36836 QBM_YDBQueueRaw insert into @DBQueueElements_368363(Object, SubObject, GenProcID) select x.uid, null, @GenProcID from ( select ra.UID_DialogTableParent as uid from deleted t join QBM_VQBMRelationALL ra 4on t.UID_DialogTable = ra.UID_DialogTableChild union select ra.UID_DialogTableChild from deleted t join QBM_VQBMRelationALL ra on t.UID_DialogTable = ra.UID_DialogTableParent5 union select t.UID_DialogTable from deleted t ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-MissingDisplayRightFill', @DBQueueElements_36836 declare @DBQueueElements_4784596 QBM_YDBQueueRaw insert into @DBQueueElements_478459 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select distinct t.TableName as7 UID from deleted d join DialogTable t on d.UID_DialogTable = t.UID_DialogTable ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-IndexCreateGenerated', @DBQueueElements_4784598 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 9