dbo.ADS_TITSBSpecificGroupBehavior

1 create   trigger ADS_TITSBSpecificGroupBehavior on TSBSpecificGroupBehavior  for insert not for Replication as begin declare @GenProcID varchar
2(38) = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted) goto start return start: declare @GUIDADSGroup QBM_YSingleGUID 
3insert into @GUIDADSGroup(UID_SingleGuid) select g.UID_ADSGroup from ADSGroup g join inserted i on g.XObjectKey = i.ObjectKeyGroup if @@ROWCOUNT > 0 begin
4 declare @DBQueueElements_ADSContactInADSGroup QBM_YDBQueueRaw insert into @DBQueueElements_ADSContactInADSGroup (object, subobject, genprocid) select 
5x.uid, null, @GenProcID from ( select uig.UID_ADSContact as uid from ADSContactInADSGroup uig join @GUIDADSGroup gg on uig.UID_ADSGroup = gg.UID_SingleGuid
6 ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_ADSContactInADSGroup declare @DBQueueElements_ADSAccountInADSGroup 
7QBM_YDBQueueRaw insert into @DBQueueElements_ADSAccountInADSGroup (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_ADSAccount
8 as uid 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