Posted by Kevin3NF on 12/18/06 20:57

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.
>

• Next in forum: Re: Weird millisecond part of datetime data in SQL Server 2000
• Prev in forum: Replacing NULL value in multiple columns in a table
• Thread view: Re: Help-Can I use 4 GB memory by SQL Server2000?

[Reply to this message]