Posted by Arnie Rowland on 12/18/06 22:10

Upgrade to Enterprise Edition.

Configuration -Maximum Capacity Specifications
2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Damon" <Damon@china.com> wrote in message
news:cuDhh.69523$YV4.18832@edtnps89...
> Thank you Kevin.
> Is there any solution to use 4 GB memory by sql2000?
>
> "Kevin3NF" <kevin@SPAMTRAP.3nf-inc.com> wrote in message
> news:uL6CwcuIHHA.4760@TK2MSFTNGP03.phx.gbl...
>> True. Standard edition is limited to 2GB
>>
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>>
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>>
>> "Damon" <Damon@china.com> wrote in message
>> news:3YChh.69507$YV4.69275@edtnps89...
>>> There is a Server with 4G Memory. I installed a SQL Server 2000 standard
>>> version on it.
>>> I heard that SQLServer2000 could use only up to 2GB memory. Is it true?
>>> How can I use those 4GB memory? I can not upgrade to SQL Server 2005 or
>>> other version because i don't want to take this risk.
>>>
>>> Thank you very much.
>>>
>>
>>
>
>

[Back to original message]