TR_CONSTITUENT_TASYNC_U

    CREATE trigger TR_CONSTITUENT_TASYNC_U on dbo.CONSTITUENT after update not for replication
    as begin
      if dbo.UFN_B2T_CONTEXTISSYNC() = 0
      begin
        update t
        set ACTIONCODE = case when ACTIONCODE=1 then 1 else 2 end
        from dbo.TA_CONSTITUENT t
        inner join INSERTED i on i.ID = t.ID

        update t
        set ACTIONCODE = case when ACTIONCODE=1 then 1 else 2 end
        from dbo.TA_ACCOUNTS t
        inner join INSERTED i on i.ID = t.ID

        update t
        set ACTIONCODE = case when ACTIONCODE=1 then 1 else 2 end
        from dbo.TA_NAMES0 t
        inner join INSERTED i on i.ID = t.ID
      end
    end