dbo.ADS_TDADSGroupInADSGroup

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