dbo.ADS_TIADSGroupInADSGroup

1  create   trigger ADS_TIADSGroupInADSGroup on ADSGroupInADSGroup  for Insert not for Replication as begin  if exists (select top 1 1 from inserted
2) goto start return start: BEGIN TRY declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')  if exists (select top 1 1 from inserted i join ADSGroup
3 g on i.UID_ADSGroupParent = g.UID_ADSGroup and 1 = g.HasReadOnlyMemberships and dbo.QBM_FGISessionContext ('Fullsync') = '' ) begin raiserror( '#LDS#Cannot add {0} because assignment to groups with read only memberships are not permitted.|ADSGroupInADSGroup|'
4, 18, 2) with nowait end declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null,
5 @GenProcID from ( select uid_ADSGroupParent as uid from inserted union select UID_ADSGroupChild from inserted union  select co.uid_ADSGroupParent as uid
6 from inserted i join ADSGroupcollection co on i.UID_ADSGroupChild = co.UID_ADSGroupChild  union select co.uid_ADSGroupParent from inserted i join ADSGroupcollection
7 co on i.UID_ADSGroupParent = co.UID_ADSGroupChild  union select co.UID_ADSGroupChild from inserted i join ADSGroupcollection co on i.UID_ADSGroupChild
8 = co.UID_ADSGroupParent  union select co.UID_ADSGroupChild from inserted i join ADSGroupcollection co on i.UID_ADSGroupParent = co.UID_ADSGroupParent 
9) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSGroupInADSGroup', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (''
10, 18, 1) WITH NOWAIT END CATCH ende: return end 
11