I'll start with the basics, please forgive me if I'm telling you something you already know.
1. The normal drive allocation process for Windows is the first partition on the first hard drive is C, first partition on the second hard drive is D, and so on. Then come the other partitions on the hard drives, followed by the optical drives. It usually takes the first hard drive on the master IDE channel as the very first hard drive unless either:
a. Another hard drive has been set as the 'active' drive and has the MBR, or
b. The BIOS settings tell it to boot from another hard drive.
2. It is possible in Win XP to have it set a particular drive letter to a particular drive and it will ignore the above default process. NB Sometimes the above will reapply if a drive is removed and it is C or D drive.
Use of Master / Slave settings normally do not affect the above process, but I have seen (with some motherboards) drive letter allocations change about on booting, when Cable Select is used.
-----------
If you wish to boot from the SATA, make sure that the BIOS sets that as the boot hard drive and do NOT set any other hard drive as a boot drive after it. Then make sure the SATA is used as the MBR drive, best to have it loaded with the OS.
Best to have the hard drives set as Master on the first IDE channel. Then make any adjustments within XP itself.