TR_OPPORTUNITYDESIGNATION_T2BINSERTUPDATE

    CREATE trigger TR_OPPORTUNITYDESIGNATION_T2BINSERTUPDATE on dbo.OPPORTUNITYDESIGNATION after insert, update not for replication
    as begin
      -- intentionally leaving off UFN_B2T_CONTEXTISSYNC condition, even changes from sync need to trigger update

        -- force re-sync of the parent row

        update dbo.B2TROWS
        set FORCEUPDATE = 1
        where BBECID in(select OPPORTUNITYID from INSERTED)
        and BBECTABLE = 'OPPORTUNITY'
        and TATABLE = 'BBEC_OPPORTUNITY'
    end