Gamespot has an article up now listing games known to have problems with Service Pack 2 for Windows XP, mostly due to security upgrades to the networking components.
If you’ve been having trouble with some of your games since installing this latest operating system update, you might want to check against the list to pinpoint where the problem might be.
Microsoft also has a list they’ve compiled of applications they know to have problems with the update, along with some possible fixes.