dbo.ADS_TDTSBSpecificGroupBehavior

1create   trigger ADS_TDTSBSpecificGroupBehavior on TSBSpecificGroupBehavior  for delete not for Replication as begin declare @GenProcID varchar(38
2) = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from deleted) goto start return start: declare @GUIDADSGroup QBM_YSingleGUID insert
3 into @GUIDADSGroup(UID_SingleGuid) select g.UID_ADSGroup from ADSGroup g join deleted i on g.XObjectKey = i.ObjectKeyGroup if @@ROWCOUNT > 0 begin declare
4 @DBQueueElements_ADSContactInADSGroup QBM_YDBQueueRaw insert into @DBQueueElements_ADSContactInADSGroup (object, subobject, genprocid) select x.uid, null
5, @GenProcID from ( select uig.UID_ADSContact as uid from ADSContactInADSGroup uig join @GUIDADSGroup gg on uig.UID_ADSGroup = gg.UID_SingleGuid ) as x
6 exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_ADSContactInADSGroup declare @DBQueueElements_ADSAccountInADSGroup QBM_YDBQueueRaw
7 insert into @DBQueueElements_ADSAccountInADSGroup (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_ADSAccount as uid
8 from ADSAccountInADSGroup uig join @GUIDADSGroup gg on uig.UID_ADSGroup = gg.UID_SingleGuid ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup'
9, @DBQueueElements_ADSAccountInADSGroup end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH EndLabel:
10 return end 
11