dbo.LDP_TUTSBSpecificGroupBehavior

1create   trigger LDP_TUTSBSpecificGroupBehavior on TSBSpecificGroupBehavior  for update not for Replication as begin declare @GenProcID varchar(38
2) = dbo.QBM_FGISessionContext('') declare @ReallyChanged QBM_YParameterList  BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select
3 top 1 1 from deleted) goto start return start: if not (update( PFDInheritOverwrite ) or update( PTDInheritOverwrite ) or update( PSIInheritOverwrite )
4 or update( PMDInheritOverwrite ) or update( ADAInheritOverwrite ) ) begin goto EndLabel end insert into @ReallyChanged(Parameter1) select ovr.ObjectKeyGroup
5 from TSBSpecificGroupBehavior ovr join deleted i on ovr.UID_TSBSpecificGroupBehavior = i.UID_TSBSpecificGroupBehavior where isnull(ovr.PFDInheritOverwrite
6,0) <> isnull(i.PFDInheritOverwrite, 0) or isnull(ovr.PTDInheritOverwrite,0) <> isnull(i.PTDInheritOverwrite, 0) or isnull(ovr.PSIInheritOverwrite,0) <>
7 isnull(i.PSIInheritOverwrite, 0) or isnull(ovr.PMDInheritOverwrite,0) <> isnull(i.PMDInheritOverwrite, 0) or isnull(ovr.ADAInheritOverwrite,0) <> isnull
8(i.ADAInheritOverwrite, 0) if @@ROWCOUNT = 0 begin goto EndLabel end declare @GUIDLDAPGroup QBM_YSingleGUID insert into @GUIDLDAPGroup(UID_SingleGuid) 
9select g.UID_LDAPGroup from LDAPGroup g join @ReallyChanged ch on g.XObjectKey = ch.Parameter1 if @@ROWCOUNT > 0 begin declare @DBQueueElements_LDAPAccountInLDAPGroup
10 QBM_YDBQueueRaw insert into @DBQueueElements_LDAPAccountInLDAPGroup (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_LDAPAccount
11 as uid from LDAPAccountInLDAPGroup uig join @GUIDLDAPGroup gg on uig.UID_LDAPGroup = gg.UID_SingleGuid ) as x exec QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPAccountInLDAPGroup'
12, @DBQueueElements_LDAPAccountInLDAPGroup end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH EndLabel:
13 return end 
14