>Hey Erik,
> My office is getting some specs on an sql server. Do you happen to know the min system requires (disk space, etc) for a server and also the system requirements for a workstation? I am going to recommend that we keep the front end VFP. Do you think that this is a good recommendation?
>
>Jeff T.

According to my SQL Admin Guide: Computer Pentium 166 or greater and DEC Alpha,
minimum 32 MB RAM (and that is really MINIMUM in my estimation! All of our SQl Servers are running 128-512 MB.), NT 4.0 Server with SP4 or later (you can run on W95/98 but I can't figure out why anyone would want to), and IE4.01 with SP 1 or later.

You didn't mention any estimated load your server will see, so it's hard to give a recommendation on exact configuration. Some rules of thumb: RAM is good. Drive space is good. Multiprocessors are good (up to a point).

We do development (we being a max of five developers) on a single processor P1-233 with 128 MB RAM and 12 gB RAID5 HD. We've been running our manufacturing applications (not our ERP) on quad Pentium Pro 200's, 256 MB RAM, and 18 gB HD successfully for over two years. This system has about 200 connected users with maybe 30-40 active at any given time.

Our workstation are mostly P2-266 or better, 32/64 MB RAM, and 4-8 gB HD. Almost all are running under NT 4.0, a few are Windows 95.

We have front-end apps built with both VFP and VB. We are moving rapidly toward a VFP middle tier and "whatever turns your crank" for the front-end. VFP works good as a front-end and so does VB. VB is our primary tool for instrumentation and test interfaces. No two organizations in the company can really agree on a back-end so we accomodate SQL, Oracle, and Informix.

Good luck Jeff, you're fun is just about to begin!