>Slight change of plan... I'm only going to be using one box for right now. I have C and D drives and was wondering if I could simply load SQL onto D and then access it the same way with my development and production apps from the C drive?

SQL Server 2000 wants to install on the same drive that the OS is install on. It requires a registry hack to get it to install on another drive. I don't remember which key needs to be changed - sorry.

-Mike