yeah we have SP2 and have had no worries with it.
does the normal XP (without SP1 or 2) ask you to verify executeables before they run? because thats what saved me from having to take the box to the computer guys to get it fixed when that virus swept thru MSN not long ago.