TR_ADDRESSVALIDATIONUPDATE_T2BDELETE

                create trigger TR_ADDRESSVALIDATIONUPDATE_T2BDELETE on dbo.ADDRESSVALIDATIONUPDATE after delete not for replication
                as begin
                if dbo.UFN_B2T_CONTEXTISSYNC() = 0
                    -- force re-sync of the parent row

                    update dbo.TA_ADDRESS
                    set ACTIONCODE = case when ACTIONCODE=1 then 1 else 2 end
                    where ID in(select ID from DELETED)
                end