From the "Maximum Capacity Specifications" within Books Online:
SQL 2k Standard Edition only supports 2GB of RAM.
SQL2k EE supports up to 64GB of RAM under the appropriate Operating System.

--
Keith Kratochvil


"Simon" <Simon@discussions.microsoft.com> wrote in message
news:FFAA80F9-D096-4045-8013-E32F0F6EC6B7@microsoft.com...
>I have a dual processor server with 4G of memory. However SQL 2000 is only
> using 1.7G. I have looked at sp_configure to get SQL to use more memory
> but I
> don`t seem to get better than 1.7G. Why is this ? What is the easiest way
> to
> increase the memory used by SQL ?
>
> Thanks
>
> Si