Microsoft has put up this KnowledgeBase article (842242) to help with some of the problems caused by SP2. It's title is "Some programs seem to stop working after you install Windows XP Service Pack 2".