1. USB Mouse will rarely work after rebooting when SP2 is installed.
Unplug it & plug it back in. Unplug it & plug it back in again. (Repeat this procedure (x) number of times while at the same time applying random mouse clicks/deskslams until mouse works.
2. good operating Printer/Scanner combo (Dell) will not work when hooked up after SP2 is installed. Neither reinstalling drivers from CD, nor Downloading updated drivers or firmware from manufacturer, nor replacing cables,
"A USB device that is connected to a USB 2.0 hub is not detected in Windows XP Service Pack 2, Windows Server 2003 Service Pack 1, or Windows Server 2003 x64 versions"
CAUSE: Microsoft Windows XP SP2 USB 2.0 driver causes an Enhanced Host Controller Interface (EHCI) specification violation.
MY OPINION (warning, I'm not a professional, but it worked)
SOLUTION: Since installing SP2 caused the problem, then revert necessary files back to the SP1 (working) version.
HOW:
After rebooting, the new hardware wizard will say it found new hardware. Normally, if you allowed it to automatically find the right files, it would take forever to search without finding the right files, and hardware will not be added. Instead, when new hardware wizard asks whether you want it to automatically search for files, don't let it. Do it manually.
Choose the device from the list then click 'have disk'. Browse to the folder on your C:\ where all drivers are stored (not sure if this folder is the same or exists on PCS other than Dell but my folder is c:\I386). First, The wizard finds the necessary USB Controllers (i.e., "USB Composite Device,” "USB Printing Support") but when continuing, it warns you that the files have not passed some logo test thing from MS . . . continue installing anyway.
IMPORTANT: Each device will have at least ONE missing file that it cannot find (i.e., usbccgp.sys, usbprint.sys). Do a search of your C:\ for this file name, and look at the detailed results for a folder having SP1 in the path. Point your Wizard to this folder for the requested file and VOILA! SUCCESS!
Once the USB controllers install a new (duplicate) device should show up (also with errors) in device manager. Follow the same steps to install drivers for these new devices and delete the original duplicate device from the list