1. Set sata operation mode to IDE in the bios. This will let windows use native IDE drivers. You loose some features such as NCQ and Hot swap. For some, this is worth the hassle free install. There is NOT a big performance hit for most systems with this option.
2. Dust off an old floppy drive and get the SATA/AHCI/RAID driver copied to it. Many motherboard makers call this the F6 disk because when windows is loading it will tell you at the bottom to hit F6 to load 3rd party driver. Hitting F6 here lets you get the driver off the disc. Some board allow a USB stick to emulate a floppy drive. This may work in your case as well.
3. Slipsteam not just the latest service pack but also the drivers needed with a program like nLite. When i last used this, it did NOT work with MCE, but is reported to work well with XP Pro.
I guess a last option would be windows 7. Since Vista windows can now load drivers for SATA/SCSI controllers off a flash drive. I have yet to need to since it seems to support many drivers internally already.
EDITED TYPO! Win7 DOES "NOW"(Oppsy i had does "NOT") allow driver loading from USB flash drives.
If in doubt when reinstalling XP, press the Function 6 key when prompted to do so even if you haven't got slipstreamed drivers or a floppy disk. Later, you'll be prompted to pop in that floppy or to hit Enter and I find hitting Enter makes XP look in more cabinets because it invariably finds the right driver without the need for a disk. If you don't press the F6 key at the beginning, it opresses on assuming PATA or no special drivers.