The Register has published a detailed article on SP2's security "improvements." Good geeky reading:

WinXP SP2 = security placebo?