Back to OIM Explorer

dbo.ADS_TDADSMachine

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on ADSMachine. Trigger parent table: ADSMachine

Source: sandbox-db sys.sql_modules

Source size: 1.201 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.

Relations

  • Trigger parent table: ADSMachine

Typed Edges

  • trigger on table ADSMachine Trigger parent table: ADSMachine
  • references source dbo.QBM_FCVElementToObjectKey1 source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL72 lines
1CREATE trigger ADS_TDADSMachine2  ON ADSMachine 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)13    SELECT @GenProcID = dbo.QBM_FGISessionContext('')14    IF EXISTS(15      SELECT TOP 1 116      FROM deleted d17      WHERE18        d.ObjectSID > ' ')19    BEGIN20      INSERT INTO ADSOtherSID(UID_ADSOtherSID,21      ObjectSID,22      DistinguishedName,23      canonicalName,24      Ident_ADSOtherSID,25      XDateInserted,26      XDateUpdated,27      XUserInserted,28      XUserUpdated,29      XObjectKey)30      SELECT31        x.UID_ADSOtherSID,32        x.ObjectSID,33        x.DistinguishedName,34        x.canonicalName,35        x.Ident_ADSOtherSID,36        x.XDateInserted,37        x.XDateUpdated,38        x.XUserInserted,39        x.XUserUpdated,40        dbo.QBM_FCVElementToObjectKey1('ADSOtherSID',41        'UID_ADSOtherSID',42        x.UID_ADSOtherSID)43      FROM(44      SELECT45        newid() AS UID_ADSOtherSID,46        d.ObjectSID,47        d.DistinguishedName,48        d.canonicalName,49        d.cn AS Ident_ADSOtherSID,50        d.XDateInserted,51        d.XDateUpdated,52        d.XUserInserted,53        d.XUserUpdated54      FROM deleted d55      WHERE56        d.ObjectSID > ' ' AND NOT EXISTS(57      SELECT TOP 1 158      FROM ADSOtherSID x59      WHERE60        x.ObjectSID = d.ObjectSID)) AS x61    END62  END TRY63  BEGIN CATCH64    EXEC QBM_PSessionErrorAdd DEFAULT65    RAISERROR('',66    18,67    1)68      WITH NOWAIT69  END CATCH70  ende:71  RETURN72END
Open raw exported source
SQL ยท Raw9 lines
1create   trigger ADS_TDADSMachine on ADSMachine  for delete not for Replication as begin  BEGIN TRY if exists (select top 1 1 from deleted) goto2 start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  if exists (select top 1 1 from deleted d where d.ObjectSID3 > ' ' ) begin insert into ADSOtherSID (UID_ADSOtherSID, ObjectSID , DistinguishedName, canonicalName, Ident_ADSOtherSID , XDateInserted, XDateUpdated,4 XUserInserted, XUserUpdated, XObjectKey) select x.UID_ADSOtherSID, x.ObjectSID , x.DistinguishedName, x.canonicalName, x.Ident_ADSOtherSID , x.XDateInserted5, x.XDateUpdated, x.XUserInserted, x.XUserUpdated, dbo.QBM_FCVElementToObjectKey1('ADSOtherSID', 'UID_ADSOtherSID', x.UID_ADSOtherSID) from( select newid6() as UID_ADSOtherSID, d.ObjectSID , d.DistinguishedName, d.canonicalName, d.cn as Ident_ADSOtherSID , d.XDateInserted, d.XDateUpdated, d.XUserInserted7, d.XUserUpdated from deleted d where d.ObjectSID > ' ' and not exists (select top 1 1 from ADSOtherSID x where x.ObjectSID = d.ObjectSID ) ) as x end 8  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 9