dbo.ADS_TDADSGroupExclusion

1CREATE trigger ADS_TDADSGroupExclusion2  ON ADSGroupExclusion 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    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 uig.UID_ADSAccount AS uid24    FROM(25    SELECT UID_ADSGroupLower AS UID_ADSGroup26    FROM deleted27    UNION28    SELECT UID_ADSGroupHigher29    FROM deleted) AS y30    JOIN ADSGroupCollection coll31      ON y.UID_ADSGroup = coll.UID_ADSGroupParent32    JOIN ADSAccountInADSGroup uig33      ON coll.UID_ADSGroupChild = uig.UID_ADSGroup AND uig.XOrigin > 0) AS x34    EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup',35      @DBQueueElements_0136    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw37    INSERT INTO @DBQueueElements_02(object,38    subobject,39    genprocid)40    SELECT41      x.uid,42      NULL,43      @GenProcID44    FROM(45    SELECT uig.UID_ADSContact AS uid46    FROM(47    SELECT UID_ADSGroupLower AS UID_ADSGroup48    FROM deleted49    UNION50    SELECT UID_ADSGroupHigher51    FROM deleted) AS y52    JOIN ADSGroupCollection coll53      ON y.UID_ADSGroup = coll.UID_ADSGroupParent54    JOIN ADSContactInADSGroup uig55      ON coll.UID_ADSGroupChild = uig.UID_ADSGroup AND uig.XOrigin > 0) AS x56    EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup',57      @DBQueueElements_0258    DECLARE @DBQueueElements_03 QBM_YDBQueueRaw59    INSERT INTO @DBQueueElements_03(object,60    subobject,61    genprocid)62    SELECT63      x.uid,64      NULL,65      @GenProcID66    FROM(67    SELECT uig.UID_ADSMachine AS uid68    FROM(69    SELECT UID_ADSGroupLower AS UID_ADSGroup70    FROM deleted71    UNION72    SELECT UID_ADSGroupHigher73    FROM deleted) AS y74    JOIN ADSGroupCollection coll75      ON y.UID_ADSGroup = coll.UID_ADSGroupParent76    JOIN ADSMachineInADSGroup uig77      ON coll.UID_ADSGroupChild = uig.UID_ADSGroup AND uig.XOrigin > 0) AS x78    EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup',79      @DBQueueElements_0380    DECLARE @DBQueueElements_04 QBM_YDBQueueRaw81    INSERT INTO @DBQueueElements_04(object,82    subobject,83    genprocid)84    SELECT85      x.uid,86      NULL,87      @GenProcID88    FROM(89    SELECT g.UID_Org AS uid90    FROM(91    SELECT UID_ADSGroupLower AS UID_ADSGroup92    FROM deleted93    UNION94    SELECT UID_ADSGroupHigher95    FROM deleted) AS y96    JOIN BaseTreeHasADSGroup g97      ON y.UID_ADSGroup = g.UID_ADSGroup) AS x98    EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-OrgHasADSGroup',99      @DBQueueElements_04100  END TRY101  BEGIN CATCH102    EXEC QBM_PSessionErrorAdd DEFAULT103    RAISERROR('',104    18,105    1)106      WITH NOWAIT107  END CATCH108  ende:109  RETURN110END