Back to OIM Explorer

dbo.ADS_TIDomainTrustsDomain

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DomainTrustsDomain. Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 4; Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 4; Bulk DBQueue insert -> ADS-K-ADSMachineInADSGroup / ADS_ZADSMachineInADSGroup at line 4; Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 7

Source: sandbox-db sys.sql_modules

Source size: 1.585 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-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 4
  • Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 4
  • Bulk DBQueue insert -> ADS-K-ADSMachineInADSGroup / ADS_ZADSMachineInADSGroup at line 4
  • Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 7
  • Bulk DBQueue insert -> ADS-K-ADSMachineInADSGroup / ADS_ZADSMachineInADSGroup at line 7
  • Bulk DBQueue insert -> ADS-K-ADSMachineInADSGroup / ADS_ZADSMachineInADSGroup at line 9
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: DomainTrustsDomain

Typed Edges

  • queues DBQueue task ADS_ZAccountInADSGroup at line 4 Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 4
  • queues DBQueue task ADS_ZContactInADSGroup at line 4 Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 4
  • queues DBQueue task ADS_ZADSMachineInADSGroup at line 4 Bulk DBQueue insert -> ADS-K-ADSMachineInADSGroup / ADS_ZADSMachineInADSGroup at line 4
  • queues DBQueue task ADS_ZContactInADSGroup at line 7 Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 7
  • queues DBQueue task ADS_ZADSMachineInADSGroup at line 7 Bulk DBQueue insert -> ADS-K-ADSMachineInADSGroup / ADS_ZADSMachineInADSGroup at line 7
  • queues DBQueue task ADS_ZADSMachineInADSGroup at line 9 Bulk DBQueue insert -> ADS-K-ADSMachineInADSGroup / ADS_ZADSMachineInADSGroup at line 9
  • trigger on table DomainTrustsDomain Trigger parent table: DomainTrustsDomain
  • 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

Referenced By

  • No direct source references extracted.

Complete Source

SQL75 lines
1CREATE trigger ADS_TIDomainTrustsDomain2  ON DomainTrustsDomain FOR3INSERT NOT FOR Replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM inserted)10    GOTO start11    RETURN start:12    DECLARE @GenProcID varchar(38)13    SELECT @GenProcID = dbo.QBM_FGISessionContext('')14    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw15    INSERT INTO @DBQueueElements_01(object,16    subobject,17    genprocid)18    SELECT19      x.uid,20      NULL,21      @GenProcID22    FROM(23    SELECT a.uid_adsaccount AS uid24    FROM inserted i25    JOIN ADSDomain d26      ON i.UID_ADSDomainTrusted= d.UID_ADSDomain27    JOIN adsaccount a28      ON d.UID_ADSDomain = a.UID_ADSDomain) AS x29    EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup',30      @DBQueueElements_0131    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw32    INSERT INTO @DBQueueElements_02(object,33    subobject,34    genprocid)35    SELECT36      x.uid,37      NULL,38      @GenProcID39    FROM(40    SELECT a.UID_ADSContact AS uid41    FROM inserted i42    JOIN ADSDomain d43      ON i.UID_ADSDomainTrusted = d.UID_ADSDomain44    JOIN ADSContact a45      ON d.UID_ADSDomain = a.UID_ADSDomain) AS x46    EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup',47      @DBQueueElements_0248    DECLARE @DBQueueElements_03 QBM_YDBQueueRaw49    INSERT INTO @DBQueueElements_03(object,50    subobject,51    genprocid)52    SELECT53      x.uid,54      NULL,55      @GenProcID56    FROM(57    SELECT a.uid_ADSMachine AS uid58    FROM inserted i59    JOIN ADSDomain d60      ON i.UID_ADSDomainTrusted = d.UID_ADSDomain61    JOIN ADSMachine a62      ON d.UID_ADSDomain = a.UID_ADSDomain) AS x63    EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup',64      @DBQueueElements_0365  END TRY66  BEGIN CATCH67    EXEC QBM_PSessionErrorAdd DEFAULT68    RAISERROR('',69    18,70    1)71      WITH NOWAIT72  END CATCH73  ende:74  RETURN75END
Open raw exported source
SQL ยท Raw11 lines
1create   trigger ADS_TIDomainTrustsDomain on DomainTrustsDomain  for Insert not for Replication as begin  BEGIN TRY if exists (select top 1 1 from2 inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') declare @DBQueueElements_01 QBM_YDBQueueRaw3 insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select a.uid_adsaccount as uid  from inserted i join4 ADSDomain d on i.UID_ADSDomainTrusted= d.UID_ADSDomain join adsaccount a on d.UID_ADSDomain = a.UID_ADSDomain ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup'5, @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID6 from ( select a.UID_ADSContact as uid  from inserted i join ADSDomain d on i.UID_ADSDomainTrusted = d.UID_ADSDomain join ADSContact a on d.UID_ADSDomain7 = a.UID_ADSDomain ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_02  declare @DBQueueElements_03 QBM_YDBQueueRaw insert8 into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select a.uid_ADSMachine as uid  from inserted i join ADSDomain9 d on i.UID_ADSDomainTrusted = d.UID_ADSDomain join ADSMachine a on d.UID_ADSDomain = a.UID_ADSDomain ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup'10, @DBQueueElements_03   END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 11