XP SP2 knows nothing about SATA drives, motherboard chipsets and such. During the install you get to press the F6 key to feed a floppy disk if the legacy support in the BIOS isn't good enough.
But after you learn all about drivers and install them, then XP SP2 will work fine.
Bob
Hello, just recently I decided to put together a computer, I had a question about Windows XP sp2.
I'm going to add this harddrive: Hitachi / 250GB / 7200 / 8MB / SATA-300 / OEM / SATA-II Hard Drive. Now I was wondering if SATA HD's are compatible with Windows XP sp2. I've read something about "Not getting the full 3MBs until you download Hitachi Drivers, the default is at 150 MBs." I understand that, but I wanted to know if XP sp2 would even work on it.. It's probably an easy answer 'yeah..' but I didn't want to order it until I knew for sure. Thanks a bunch.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic