From: Ellen K. 

The standard edition of Windows 2000 Server can't use more than 4 GB of RAM
and neither can the standard edition of SQL Server 2000.  Enterprise
edition for SS can use I think 16 but is four times the price of standard. 
The machine I wanted to run this ugly process on has 3 GB... it barfed with
a "not enough memory" error.

On Fri, 17 Dec 2004 12:40:05 -0600, "Glenn Meadows"
 wrote in message :

>I believe that is correct, and depending on the option you set for either
>full, or mini-dumps, will determine the minimum size you can make the swap
>file.
>
>Hell, I'd just throw a TON of ram in the machine and be done with it.
>
>Our 8way Dell has 4 gig of ram in it, and I've never seen it use all of it,
>swap file always shows currently allocated at the minimum amount defined.
>When it was purchased, it was a no brainer to get as much as they could get,
>rather than try to add it later.

--- BBBS/NT v4.01 Flag-5