Revisiting type-II see-saw: present limits and future prospects at LHC