A repair install doesn't require the addition of SATA drivers...since it is a repair on an already existing Windows install.
The repair will simply remove all updates since the date of the repair disk used...and replace all system files. All programs installed, data files, settings,etc. will remain as they currently are.
A repair install will not address either malware or hardware situations that prevent the system from functioning properly.
As for telling whether a hard drive is SATA or IDE...you can just look in Device Manager. SATA hard drives will (probably) be reflected SCSI Disk Devices under the Disk Drive category, while IDE drives are reflected simply by manufacturer and model.
Windows is not set up to allow a user to do a repair install with an earlier version of the O/S. I tried this one day (just to see what would happen) and the result was either a dual install or a clean install which erased my previous install (it was some time ago and I don't remember which).
If the system is current through SP3, then make a slipstreamed SP3 CD and do the repair. If current through SP2, same thing for SP2.
There are various sites which tell of various ways to make a slipstreamed XP CD. I think that using the nLite website is probably the easiest, but that's just another opinion of mine. I have used it and I've used this site's guidance and guidance provided on the Elder Geek and Paul Thurrott sites...all were successful for me.http://www.michaelstevenstech.com/XPrepairinstall.htm
Slipstreamed Windows XP CD Using SP2 - http://www.theeldergeek.com/slipstreamed_xpsp2_cd.htm
nLite - Deployment Tool for the bootable Unattended Windows installation - Guide - http://www.nliteos.com/guide/