I had LOTS of problems with SP2 on my last motherboard - an MSI board with a VIA PT880 chipset. It would cause random reboots while browsing the Internet. I used the downloaded network install of SP2 on that machine.
When I built my new system the other night, I updated to SP2 immediately using Windows Update. So far, no problems at all. It's running smooth.