I installed it a few weeks back with NO problems during the install and it works just fine.

As squirt noted there's all sorts of new goodies and settings that come with SP2. You may need to tweak your system afterwards.

Make sure you backup your computer. Make sure you also create a restore point by using your System Restore Wizard.

The download took me 30 mins on cable and 30 mins for the actual install.