dbo.LDP_TUTSBBehavior

1 create   trigger LDP_TUTSBBehavior on TSBBehavior  for Update not for Replication as begin  declare @TSBBehaviorsToCheck QBM_YSingleGUID     BEGIN
2 TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38
3) select @GenProcID = dbo.QBM_FGISessionContext('')  if update(PTDInheritGroup) or update(PFDInheritGroup) or update(PMDInheritGroup) or update(PSIInheritGroup
4) or update(ADAInheritGroup) begin insert into @TSBBehaviorsToCheck (UID_SingleGuid ) select distinct r.uid_TSBBehavior from TSBBehavior r join deleted
5 d on r.uid_TSBBehavior = d.uid_TSBBehavior where (isnull(r.PTDInheritGroup,0) <> isnull(d.PTDInheritGroup,0) or isnull(r.PFDInheritGroup,0) <> isnull(d.PFDInheritGroup
6,0) or isnull(r.PMDInheritGroup,0) <> isnull(d.PMDInheritGroup,0) or isnull(r.PSIInheritGroup,0) <> isnull(d.PSIInheritGroup,0) or isnull(r.ADAInheritGroup
7,0) <> isnull(d.ADAInheritGroup,0) ) if 0 < (select count(*) from @TSBBehaviorsToCheck) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01
8 (object, subobject, genprocid) select x.uid, null, @GenProcID from (  select a.UID_LDAPAccount as uid from LDAPAccount a join @TSBBehaviorsToCheck c on
9 a.UID_TSBBehavior = c.UID_SingleGuid  ) as x exec QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPAccountInLDAPGroup', @DBQueueElements_01 end end    END TRY BEGIN
10 CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
11