How much memory can SQL 2000 Standard Edition utilize

How much memory can SQL 2000 Standard Edition utilize?
For some reason I thought it was 4 GB, but when I looked
at the hardware specification it comes up with 2 GB. I
guess I really never paid much attention to this.
OR, does the service pack increase it to 4 GB and that's
why I have 4 GB in my head.
Or, is the theory that the OS will use 2 GB and dedicating
the other 2 GB to SQL.
Also, thought I have seen in the SQL Enterprise Manager
that I was able to slide the memory to 4 GB as well.2 gb.
Please refer to the article in BOL entitled, "Maximum Capacity
Specifications".
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:22e9c01c45de6$68234660$a401280a@.phx
.gbl...
> How much memory can SQL 2000 Standard Edition utilize?
> For some reason I thought it was 4 GB, but when I looked
> at the hardware specification it comes up with 2 GB. I
> guess I really never paid much attention to this.
> OR, does the service pack increase it to 4 GB and that's
> why I have 4 GB in my head.
> Or, is the theory that the OS will use 2 GB and dedicating
> the other 2 GB to SQL.
> Also, thought I have seen in the SQL Enterprise Manager
> that I was able to slide the memory to 4 GB as well.
>|||What is BOL? What is the link?

>--Original Message--
>2 gb.
>Please refer to the article in BOL entitled, "Maximum
Capacity
>Specifications".
>"Lee" <anonymous@.discussions.microsoft.com> wrote in
message
> news:22e9c01c45de6$68234660$a401280a@.phx
.gbl...
dedicating[vbcol=seagreen]
>
>.
>|||BOL - SQL Server Books online.
Tahnks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2270401c45de9$b5cde7f0$a601280a@.phx
.gbl...[vbcol=seagreen]
> What is BOL? What is the link?
>
> Capacity
> message
> dedicating|||SQL Server Books Online. It's SQL Server's help file... Check out
Programs -> Microsoft SQL Server -> Books Online. Or, click Help from
within Query Analyzer or Profiler.
<anonymous@.discussions.microsoft.com> wrote in message
news:2270401c45de9$b5cde7f0$a601280a@.phx
.gbl...[vbcol=seagreen]
> What is BOL? What is the link?
>
> Capacity
> message
> dedicating|||Does anyone have a link to the Maximum Capacity Specifications for Win 2003
Server editions? Also for SBS Premium 2003?
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uchVeeeXEHA.3044@.TK2MSFTNGP09.phx.gbl...
> 2 gb.
> Please refer to the article in BOL entitled, "Maximum Capacity
> Specifications".
> "Lee" <anonymous@.discussions.microsoft.com> wrote in message
> news:22e9c01c45de6$68234660$a401280a@.phx
.gbl...
>|||That would be better answered in one of the Windows groups
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Victoria Yudin" <victoria@.flex-solutions.com> wrote in message
news:%23qDd$yhXEHA.1128@.TK2MSFTNGP10.phx.gbl...
> Does anyone have a link to the Maximum Capacity Specifications for Win
2003
> Server editions? Also for SBS Premium 2003?
>
> "Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
> news:uchVeeeXEHA.3044@.TK2MSFTNGP09.phx.gbl...
>sql

How much memory can SQL 2000 Standard Edition utilize

How much memory can SQL 2000 Standard Edition utilize?
For some reason I thought it was 4 GB, but when I looked
at the hardware specification it comes up with 2 GB. I
guess I really never paid much attention to this.
OR, does the service pack increase it to 4 GB and that's
why I have 4 GB in my head.
Or, is the theory that the OS will use 2 GB and dedicating
the other 2 GB to SQL.
Also, thought I have seen in the SQL Enterprise Manager
that I was able to slide the memory to 4 GB as well.
2 gb.
Please refer to the article in BOL entitled, "Maximum Capacity
Specifications".
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:22e9c01c45de6$68234660$a401280a@.phx.gbl...
> How much memory can SQL 2000 Standard Edition utilize?
> For some reason I thought it was 4 GB, but when I looked
> at the hardware specification it comes up with 2 GB. I
> guess I really never paid much attention to this.
> OR, does the service pack increase it to 4 GB and that's
> why I have 4 GB in my head.
> Or, is the theory that the OS will use 2 GB and dedicating
> the other 2 GB to SQL.
> Also, thought I have seen in the SQL Enterprise Manager
> that I was able to slide the memory to 4 GB as well.
>
|||2 gb.
Please refer to the article in BOL entitled, "Maximum Capacity
Specifications".
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:22e9c01c45de6$68234660$a401280a@.phx.gbl...
> How much memory can SQL 2000 Standard Edition utilize?
> For some reason I thought it was 4 GB, but when I looked
> at the hardware specification it comes up with 2 GB. I
> guess I really never paid much attention to this.
> OR, does the service pack increase it to 4 GB and that's
> why I have 4 GB in my head.
> Or, is the theory that the OS will use 2 GB and dedicating
> the other 2 GB to SQL.
> Also, thought I have seen in the SQL Enterprise Manager
> that I was able to slide the memory to 4 GB as well.
>
|||What is BOL? What is the link?

>--Original Message--
>2 gb.
>Please refer to the article in BOL entitled, "Maximum
Capacity
>Specifications".
>"Lee" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:22e9c01c45de6$68234660$a401280a@.phx.gbl...
dedicating
>
>.
>
|||What is BOL? What is the link?

>--Original Message--
>2 gb.
>Please refer to the article in BOL entitled, "Maximum
Capacity
>Specifications".
>"Lee" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:22e9c01c45de6$68234660$a401280a@.phx.gbl...
dedicating
>
>.
>
|||BOL - SQL Server Books online.
Tahnks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2270401c45de9$b5cde7f0$a601280a@.phx.gbl...[vbcol=seagreen]
> What is BOL? What is the link?
> Capacity
> message
> dedicating
|||BOL - SQL Server Books online.
Tahnks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2270401c45de9$b5cde7f0$a601280a@.phx.gbl...[vbcol=seagreen]
> What is BOL? What is the link?
> Capacity
> message
> dedicating
|||SQL Server Books Online. It's SQL Server's help file... Check out
Programs -> Microsoft SQL Server -> Books Online. Or, click Help from
within Query Analyzer or Profiler.
<anonymous@.discussions.microsoft.com> wrote in message
news:2270401c45de9$b5cde7f0$a601280a@.phx.gbl...[vbcol=seagreen]
> What is BOL? What is the link?
> Capacity
> message
> dedicating
|||SQL Server Books Online. It's SQL Server's help file... Check out
Programs -> Microsoft SQL Server -> Books Online. Or, click Help from
within Query Analyzer or Profiler.
<anonymous@.discussions.microsoft.com> wrote in message
news:2270401c45de9$b5cde7f0$a601280a@.phx.gbl...[vbcol=seagreen]
> What is BOL? What is the link?
> Capacity
> message
> dedicating
|||Does anyone have a link to the Maximum Capacity Specifications for Win 2003
Server editions? Also for SBS Premium 2003?
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:uchVeeeXEHA.3044@.TK2MSFTNGP09.phx.gbl...
> 2 gb.
> Please refer to the article in BOL entitled, "Maximum Capacity
> Specifications".
> "Lee" <anonymous@.discussions.microsoft.com> wrote in message
> news:22e9c01c45de6$68234660$a401280a@.phx.gbl...
>