Originally posted by: mechBgon
Originally posted by: Googer
While not perfect the only thing in service pack2 that is worth anythng to me is the NX protection. It will only function if you hardware supports it. Since he is running Norton AV there is little need for it in the first place. You can get similar or better protection from 3rd party software, like sygate. Rather than installing SP2. It works great for many, but there are a few people where it has cause headaches.
Well, yes and no. Hardware-enforced Data Execution Prevention requires a supporting CPU. Software Data Execution Prevention is also new with SP2, and it actually
doesn't require a CPU with NX-bit capabilities.
Software-enforced DEP
An additional set of data execution prevention security checks have been added to Windows XP SP2. These checks, known as software-enforced DEP, are designed to mitigate exploits of exception handling mechanisms in Windows. Software-enforced DEP runs on any processor which is capable of running Windows XP SP2. By default, software-enforced DEP only protects limited system binaries, regardless of the hardware-enforced DEP capabilities of the processor.
from
Microsoft's info
The kernel also got recompiled and quite a bit of other stuff. Good reading in this thread:
link.
The first issue I had with SP2 myself was that I had to disable Passive FTP in order to use IE for FTP purposes. So yeah, nothing's perfect

My siblings and parents have three SP2-equipped rigs among them and I haven't had any horror stories come of that. They were all clean installs, however, SP2 was not being installed over the top of viruses, worms, trojans or spyware.