I just put it on and it is pretty nice, although, I don't have my PC as a server at all, so I will not see too many newer features at work.
I will like to say to anyone that installs it, that you cannot use a generic kernal bootup file. So if you changed your boot screen, put it back or sp2 will not install. SP2 is basically a new version of xp, so the boot file will not work after installing sp2. I however just changed my boot.ini file to see the other boot screen as a new operating system. So it was pretty easy to just change boot normally.
Also, windows seems to start up faster, although, it could be just the excitement.
Oh yah, one more thing. When you first start windows, it will ask you if you want to turn on auto-update. Well, turns out that you don't have a choice. I said no and that I will look for updates myself. It showed it off, but I restarted the computer to find auto-updater enabled. So, if you don't want auto-update on, you will have to turn it off anyways and that question is just to trick you
http://www.fileforums.com/images/smilies/rolleyes.gif.