dbo.LDP_TULDAPAccount

1create   trigger LDP_TULDAPAccount on LDAPAccount  for Update not for Replication as begin  declare @QBM_BitPatternXMarkedForDel_OutStanding int
2 = dbo.QBM_FGIBitPatternXMarkedForDel('|OutStanding|', 0)  BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from
3 deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  if update(uid_person) begin declare
4 @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uid_person
5 as uid from inserted where uid_person > ' ' union select uid_person as uid from deleted where uid_person > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'LDP-K-PersonHasObject'
6, @DBQueueElements_01 end if update(uid_person)  or update(IsGroupAccount) or update(uid_LDAPContainer) or update(UID_TSBBehavior) or update(MatchPatternForMembership
7) or update(AccountDisabled)  or update(XMarkedForDeletion) begin declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, 
8subobject, genprocid) select x.uid, null, @GenProcID from (select a.UID_LDAPAccount as uid from LDAPAccount a join deleted d on a.UID_LDAPAccount = d.UID_LDAPAccount
9 where   isnull(d.UID_Person,'') <> isnull(a.UID_Person,'') or isnull(d.IsGroupAccount,0) <> isnull(a.IsGroupAccount,0) or isnull(d.uid_LDAPContainer,''
10) <> isnull(a.uid_LDAPContainer,'') or isnull(d.UID_TSBBehavior,'') <> isnull(a.UID_TSBBehavior,'') or isnull(d.MatchPatternForMembership,0) <> isnull(a.MatchPatternForMembership
11,0) or isnull(d.AccountDisabled,0) <> isnull(a.AccountDisabled,0)  or (d.XMarkedForDeletion ^ a.XMarkedForDeletion ) & @QBM_BitPatternXMarkedForDel_OutStanding
12 > 0 ) as x exec QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPAccountInLDAPGroup', @DBQueueElements_03 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default 
13RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
14