I just got done installing service pack 2, and then my computer restarts everytime windows tried to boot.
I reset my bios to it's default settings (I was overclocked with no problems previously), and now windows will start up but it will then restart after all the startup programs have finished loading.
Unless Sp2 has a built in rollback feature, I don't think there is anything I can do because I did not have system restore enabled.