TR_ADDRESS_TASYNC_U (Trigger)

            
             create trigger TR_ADDRESS_TASYNC_U on dbo.ADDRESS 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_ADDRESS t
                  inner join INSERTED i on i.ID = t.ID
                end
             end