SSE2 is Intel's Streaming SIMD (Single Instruction Multiple Data) Extensions the Second
The first generation was just called SSE. Prior to SSE was MMX. The whole concept behind the technology is dedicated hardware for doing high speed vector calculations used in 3D and other graphics applications. Whereas MMX was designed for 64 bit integer registers SSE was designed to work with 128 bit floating point data structures. SSE2 was created to also support 128 bit integer data structures in the XMM registers. (SSE3 came next and now SSE4 for Core duo and later)
Some processors such as Celeron which do not have these onboard capabilities and are dirt cheap in cost by comparison were used by the truckload in bargain basement computers. People would figure ha ha ha look how cheap their computer was cost wise, until they ran into the issues of wanting to run graphics applications. Then they would notice at how slow their graphics apps would run because the processor didn't have the dedicated chipset. Later on companies such as Adobe started creating software which would only execute with these graphics chip extensions present.
AMD's technology was called 3DNow! and then 3DNow! Professional. 3D Now Professional used same instruction calls as SSE and was cross compatible. AMD these days supports SSE2, SSE3 etc. depending on the processor.
So basically, he is telling you it is time to upgrade your computer. This was a requirement as of PPro 2, I found out when trying to install it on an old AMD. Newer AMDs will be fine.