Back to OIM Explorer

dbo.ADS_TUDomain

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on ADSDomain. Bulk DBQueue insert -> ADS-K-BaseTreeOwnsObject / ADS_ZBaseTreeOwnsObject at line 7; Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 7; Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 15; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 2.459 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

  • Bulk DBQueue insert -> ADS-K-BaseTreeOwnsObject / ADS_ZBaseTreeOwnsObject at line 7
  • Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 7
  • Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 15
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: ADSDomain

Typed Edges

  • queues DBQueue task ADS_ZBaseTreeOwnsObject at line 7 Bulk DBQueue insert -> ADS-K-BaseTreeOwnsObject / ADS_ZBaseTreeOwnsObject at line 7
  • queues DBQueue task ADS_ZAccountInADSGroup at line 7 Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 7
  • queues DBQueue task ADS_ZAccountInADSGroup at line 15 Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 15
  • trigger on table ADSDomain Trigger parent table: ADSDomain
  • 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
  • references source dbo.QER_PITShopHelperFill source text reference
  • references source dbo.QER_PITShopHelperFill_Recalc source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL113 lines
1CREATE trigger ADS_TUDomain2  ON adsdomain FOR3UPDATE NOT FOR Replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM inserted)10    GOTO start11    IF EXISTS(12      SELECT TOP 1 113      FROM deleted)14    GOTO start15    RETURN start:16    DECLARE @GenProcID varchar(38)17    SELECT @GenProcID = dbo.QBM_FGISessionContext('')18    DECLARE @errno int19    DECLARE @errmsg nvarchar(255)20    DECLARE @Parameter nvarchar(1000)21    IF22    UPDATE(uid_AERoleOwner)23    BEGIN24      DECLARE @RecalcParameter_01 QBM_YCursorBuffer25      INSERT INTO @RecalcParameter_01(UID1,26      ObjectKey1,27      Ident1)28      SELECT29        'TSB-PWODecisionRule-TO',30        i.XObjectKey,31        'I'32      FROM inserted i33      UNION all34      SELECT35        'QER-PWODecisionRule-OX',36        i.XObjectKey,37        'I'38      FROM inserted i39      EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,40        @GenprocID41    END42    IF43    UPDATE(uid_AERoleOwner)44    BEGIN45      DECLARE @DBQueueElements_02 QBM_YDBQueueRaw46      INSERT INTO @DBQueueElements_02(object,47      subobject,48      genprocid)49      SELECT50        x.uid,51        NULL,52        @GenProcID53      FROM(54      SELECT d.UID_ADSDomain AS uid55      FROM deleted d) AS x56      EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-BaseTreeOwnsObject',57        @DBQueueElements_0258    END59    IF60    UPDATE(UID_ADSForest)61    BEGIN62      IF EXISTS(63        SELECT TOP 1 164        FROM ADSDomain neu65        JOIN deleted alt66          ON neu.UID_ADSDomain = alt.UID_ADSDomain AND isnull(alt.UID_ADSForest, '') <> isnull(neu.UID_ADSForest,67      ''))68      BEGIN69        DECLARE @DBQueueElements_03 QBM_YDBQueueRaw70        INSERT INTO @DBQueueElements_03(object,71        subobject,72        genprocid)73        SELECT74          x.uid,75          NULL,76          @GenProcID77        FROM(78        SELECT a.UID_ADSAccount AS uid79        FROM ADSDomain n80        JOIN deleted d81          ON n.UID_ADSDomain = d.UID_ADSDomain AND isnull(d.UID_ADSForest, '') <> isnull(n.UID_ADSForest, '')82        JOIN ADSAccount a83          ON a.UID_ADSDomain = n.UID_ADSDomain84        JOIN ADSAccountInADSGroup uig85          ON a.UID_ADSAccount = uig.UID_ADSAccount AND uig.XOrigin > 086        JOIN ADSGroup g87          ON uig.UID_ADSGroup = g.UID_ADSGroup AND g.UID_ADSDomain <> n.UID_ADSDomain88        UNION89        SELECT a.UID_ADSAccount AS uid90        FROM ADSDomain n91        JOIN deleted d92          ON n.UID_ADSDomain = d.UID_ADSDomain AND isnull(d.UID_ADSForest, '') <> isnull(n.UID_ADSForest, '')93        JOIN ADSGroup g94          ON g.UID_ADSDomain = n.UID_ADSDomain95        JOIN ADSAccountInADSGroup uig96          ON uig.UID_ADSGroup = g.UID_ADSGroup AND uig.XOrigin > 097        JOIN ADSAccount a98          ON a.UID_ADSAccount = uig.UID_ADSAccount AND a.UID_ADSDomain <> n.UID_ADSDomain) AS x99        EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup',100          @DBQueueElements_03101      END102    END103  END TRY104  BEGIN CATCH105    EXEC QBM_PSessionErrorAdd DEFAULT106    RAISERROR('',107    18,108    1)109      WITH NOWAIT110  END CATCH111  ende:112  RETURN113END
Open raw exported source
SQL ยท Raw17 lines
1create   trigger ADS_TUDomain on adsdomain  for Update not for Replication as begin  BEGIN TRY if exists (select top 1 1 from inserted) goto start2 if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') declare3 @errno int declare @errmsg nvarchar(255) declare @Parameter nvarchar(1000) if update(uid_AERoleOwner) begin declare @RecalcParameter_01 QBM_YCursorBuffer4 insert into @RecalcParameter_01 (UID1, ObjectKey1, Ident1) select 'TSB-PWODecisionRule-TO', i.XObjectKey, 'I' from inserted i union all select 'QER-PWODecisionRule-OX'5, i.XObjectKey, 'I'  from inserted i exec QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID end  if update(uid_AERoleOwner) begin declare @DBQueueElements_026 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select d.UID_ADSDomain as uid from7 deleted d ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-BaseTreeOwnsObject', @DBQueueElements_02 end  if update(UID_ADSForest)  begin          if exists 8(select top 1 1 from ADSDomain neu join deleted alt on neu.UID_ADSDomain = alt.UID_ADSDomain and isnull(alt.UID_ADSForest,'') <> isnull(neu.UID_ADSForest9,'') ) begin  declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID10 from (  select a.UID_ADSAccount as uid from ADSDomain n join deleted d on n.UID_ADSDomain = d.UID_ADSDomain and isnull(d.UID_ADSForest,'') <> isnull(n.UID_ADSForest11,'')  join ADSAccount a on a.UID_ADSDomain = n.UID_ADSDomain join ADSAccountInADSGroup uig on a.UID_ADSAccount = uig.UID_ADSAccount and uig.XOrigin > 012  join ADSGroup g on uig.UID_ADSGroup = g.UID_ADSGroup  and g.UID_ADSDomain <> n.UID_ADSDomain  union select a.UID_ADSAccount as uid from ADSDomain n join13 deleted d on n.UID_ADSDomain = d.UID_ADSDomain and isnull(d.UID_ADSForest,'') <> isnull(n.UID_ADSForest,'')  join ADSGroup g on g.UID_ADSDomain = n.UID_ADSDomain14 join ADSAccountInADSGroup uig on uig.UID_ADSGroup = g.UID_ADSGroup and uig.XOrigin > 0  join ADSAccount a on a.UID_ADSAccount = uig.UID_ADSAccount  and15 a.UID_ADSDomain <> n.UID_ADSDomain  ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup', @DBQueueElements_03 end end END TRY BEGIN CATCH 16exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 17