>Is XP Prof a good platform to run a production SQL server on? What OS version is best in your opinion?

Windows XP Pro is a workstation OS, not a server OS. At this point in time, your best bet is Windows 2000 Server. You'll have to decide which edition (Standard, Advanced, DataCenter) based on the load that will be placed on the server.

-Mike