I removed it about 2 mos ago.
The problems I had, for example, were getting MCafee AV to install, getting my printer recognized and a myriad of services were locked out to even the admin (all part of the security/firewall "features").
When I had enough and backed out of SP2 it brought me back to XP at a pre-SP1 level. I therefor had to install SP1 all over again. But when I did and the PC rebooted when it tried coming back up Windows would not load at all. It was gone....trashed. I ended up doing a complete reformat and reinstall of XP.
I recommend folks WAIT until they flesh out the many bugs that they did not fix before release. Let others be the guinea pigs. I usually do that but a coworker had great things to say about SP2. Well, until he too experienced major problems. But by then I was already knee deep it.