Posted by Russ Rose on 12/19/06 02:06

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns989DEE520DF4DYazorman@127.0.0.1...
> Damon (Damon@china.com) writes:
>> Thank you Kevin.
>> Is there any solution to use 4 GB memory by sql2000?
>
> Upgrade to Enterprise Edition of SQL 2000.
>
> Which is quite more expensive than moving to SQL 2005 Standard, I believe.

Would a "Named Instance" on SQL 2000 Standard be able to use most of the
remaining half of the 4GB? When I expirimented with named instances back in
2001 - and decided not to use them in a production environment - I only had
2GB in the server.

Even if possible I'm not sure this would be a good solution, just wondering
what the behavior is.

>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]