dbo.ADS_TDADSGroupCollection

1create   trigger ADS_TDADSGroupCollection on ADSGroupCollection  for Delete not for Replication as begin  if exists (select top 1 1 from deleted
2) goto start return start: BEGIN TRY declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') declare @DBQueueElements_01 QBM_YDBQueueRaw
3 insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select a.uid_person as uid from ADSAccountInADSGroup
4 uig join (select uid_ADSGroupParent as UID_Group from deleted union select UID_ADSGroupChild from deleted ) as x on x.uid_group = uig.uid_ADSGroup and
5 uig.XOrigin > 0 and uig.XIsInEffect = 1 join ADSAccount a on uig.UID_ADSAccount = a.uid_ADSaccount where a.uid_person > ' ' union select a.uid_person 
6as uid from ADSContactInADSGroup uig join (select uid_ADSGroupParent as UID_Group from deleted union select UID_ADSGroupChild from deleted ) as x on x.uid_group
7 = uig.uid_ADSGroup and uig.XOrigin > 0 and uig.XIsInEffect = 1 join ADSContact a on uig.UID_ADSContact = a.uid_ADSContact where a.uid_person > ' ' ) as
8 x exec QBM_PDBQueueInsert_Bulk 'ADS-K-PersonHasObject', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02
9 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct uig.UID_Org as uid from BaseTreeHasADSGroup uig join (select uid_ADSGroupParent
10 as UID_Group from deleted union select UID_ADSGroupChild from deleted ) as x on x.uid_group = uig.uid_ADSGroup and uig.XOrigin > 0  ) as x exec QBM_PDBQueueInsert_Bulk
11 'ADS-K-BaseTreeHasObject', @DBQueueElements_02 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende:
12 return end 
13