I've been reading posts and MS sites, and see tons of info on the 3GB
Switch, AWE and PAE. I understand that Win2K Advanced or Data Center is
necessary to use > 2GB, but I haven't found any definitive statements on SQL
edition.

If I have Win2K AE and SQL2K Standard, can I use the 3GB boot.ini switch?
If so, I would imagine that I could use a 4GB server, with 3GB used by SQL.
The 3GB switch does NOT use AWE, which requires SQL2K EE.

The reason I ask is that we have Win2K Server and SQL2K standard, and we're
looking for the cheapest route to allow us to jump to 4GB. Win2K is a
relatively cheap upgrade, SQL is a VERY expensive one.


Tony



MS Sql Server LazyDBA home page