dbo.ADS_TUADSContact

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