People love to make SP2 into a whipping boy for every little thing that goes wrong, when it really does tend to do the opposite.
My best guess for your problem would be that you've got a malware problem, and the malware only really becomes active when there's some kind of network connection.
I have a question, and I apologize if I am asking this in the wrong forum.
I have a Compaq computer with several fans in it that are multiple speeds, and a built in memory card reader, and a DVD RW, (and a 19" LCD Monitor with speakers, and a Samsung Color Laser Printer, )
...................and Windows XP SP2
I Still have the same Windows XP SP2 that people say is the cause of many computer games to not work. Nothing else has changed that I know of (unless Microsoft has been installing updates to fix this problem) The only difference is that right now my computer is not connected to the internet (and probably won't be until I finish getting ready for college and start moving there) and I started to play the games and the error messages didn't come up. Does anybody know how the games are able to suddenly work again??

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic