Is your digital camera acting strangely since your XP SP2 upgrade? Things not quite right on the 1394 device front? If so, then you may need the Microsoft KB885222 update, which addresses these issues.
Microsoft have confirmed that after an SP2 install, users may experience problems with the performance of 1394 devices, including performance degradation. A digital camera that uses S400 speed is an example of such a device which may fall foul of this problem, which is caused by SP2 changing 1394b ports to S100 speed when you upgrade.