Max memory for SQL 2000 standard edition

Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4 GB.
Please, can you tell me which is really true. I need to buy right edition of
sql server...
thanksHi
SQL Server Standard Edition has a 2GB memory limitation.
Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB is
not supported)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Roman Snajdr" wrote:

> Hi, according to Microsoft max. memory is 2 GB. Someone says it is 4 GB.
> Please, can you tell me which is really true. I need to buy right edition
of
> sql server...
> thanks
>
>|||Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> SQL Server Standard Edition has a 2GB memory limitation.
> Windows 2000/2003 Standard Edition has a 4GB memory limitation (but /3GB i
s
> not supported)
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Roman Snajdr" wrote:
>|||No
2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the patch
level.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kathy" <Kathy@.discussions.microsoft.com> wrote in message
news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...[vbcol=seagreen]
> Does SP3, or any previous version of SP help expend it to 3GB? Thanks.
> "Mike Epprecht (SQL MVP)" wrote:
>|||In another dialog, you said something about switch /3gb in boot.ini. How doe
s
that works? Also in the same thread of the discussion, another person said
2GB can be used even though the switch is set up. Are there officail
documents available on this issue from MSFT? Thanks.
"Mike Epprecht (SQL MVP)" wrote:

> No
> 2GB is the maximum for SQL Server 2000 32 bit Standard, no matter the patc
h
> level.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> news:EC72F4FF-7B89-4547-8149-49FD98C975FD@.microsoft.com...
>
>|||Hi Kathy
This is the official word from Microsoft:
How to configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/defaul...kb;en-us;274750
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Kathy" <Kathy@.discussions.microsoft.com> wrote in message
news:93BFF759-501C-4126-A75D-971E2C676A30@.microsoft.com...
> In another dialog, you said something about switch /3gb in boot.ini. How
> does
> that works? Also in the same thread of the discussion, another person said
> 2GB can be used even though the switch is set up. Are there officail
> documents available on this issue from MSFT? Thanks.
> "Mike Epprecht (SQL MVP)" wrote:
>
>|||Thanks Kalen. That helps a lot.
"Kalen Delaney" wrote:

> Hi Kathy
> This is the official word from Microsoft:
> How to configure memory for more than 2 GB in SQL Server
> http://support.microsoft.com/defaul...kb;en-us;274750
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "Kathy" <Kathy@.discussions.microsoft.com> wrote in message
> news:93BFF759-501C-4126-A75D-971E2C676A30@.microsoft.com...
>
>