After reading this thread, i find it interesting that we as IT/IS professionals have sided (in thinking) with the ordinary Joe (no offence to anyone by that name) where it concerns wireless connectivity using Windows XP SP 2. I use SP2 exclusively on all machines that I have and support. In fact I would suggest that your machines are at greater risk without SP2.
As far as wireless connectivity, I have found that the majority of my problems have stemed from poorly written drivers/firmware that were included with the device/card. When these were updated the seeming SP related problems went away. The fact is SP2 makes Windows XP the most secure desktop OS MS has ever published. There are security features that most "professionals" have yet to enable or take advantage of. For example the firewall can be so completely customized that it is unnecessary to purchase anything else (for your home/end user system that is).
As an IT/IS professional you need to know what you are getting into before you decide to any updates or deployments. A good engineer will look at the pro/cons before making any decision and test his/her theories thouroughly so there will be no doubt as to the outcome. Poor planning is usually and indication that one is a poor engineer. :(
In general I have experienced virtually no problems with SP2 and wireless connectivity using multiple vendors, after being armed with whitepapers and general test scenarios. We can't let our profession degrade to the point where we cannot look at the problems/challenges straight in the face and handle them like the pros we are supposed to be. Anyway, my two cents.
Lewis Palmer Jr., MCSA, MCP