TR_EXCHANGECONTACTSYNC_UPDATED

                    CREATE trigger TR_EXCHANGECONTACTSYNC_UPDATED on dbo.EXCHANGECONTACTSYNC after update not for replication
                    as begin
                        if update(APPUSERIDSETREGISTERID) or update(CONSTITUENTIDSETREGISTERID) or update(EXCHANGECONTACTCATEGORYCODEID) or update(SPECIFICAPPUSERID) or update(PAGEDEFINITIONCATALOGID) or update(APPLYTOCODE) begin
                            update ecs set ecs.LASTRUNON = null, ecs.CHANGEDBYID = i.CHANGEDBYID from dbo.EXCHANGECONTACTSYNC ecs inner join inserted i on ecs.ID = i.ID 
                        end
                    end