Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Difference between SQL Server Standard Edition and Enterprise Edition.
- Thread starter SqlKing
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
Enterprise Edition gives you some additional features as well as access to more memory and CPUs.
Standard Edition can only access 2 Gigs or Memory and 4 CPUs. Enterprise Edition doesn't have these limits.
Enterprise Edition also give you Log Shipping, Federated databases, Clustering ability as well as a few other features.
Somewhere Microsoft has a chart which compairs the two. There is also a price difference. Enterprise Edition costs quite a bit more.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Standard Edition can only access 2 Gigs or Memory and 4 CPUs. Enterprise Edition doesn't have these limits.
Enterprise Edition also give you Log Shipping, Federated databases, Clustering ability as well as a few other features.
Somewhere Microsoft has a chart which compairs the two. There is also a price difference. Enterprise Edition costs quite a bit more.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Thread starter
- #3
mrdenny
Programmer
- May 27, 2002
- 11,595
no problem.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
