You can install SQL Server 2000 Personal Edition on the same machine as SQL
Server 7.0, but you must give the SQL Server 2000 a distinct named instance.
Then the two SQL Servers will not have the same server name.
The SQL Server 2000 instance name will be a combination of the machine name,
backslash, and the instance name.
Also, SQL Server 2000 will overwrite the SQL Server 7.0 client tools
(Enterprise Manager, Query Analyzer, Profiler), and you can manage SQL
Server 7.0 using the 2000 tools.
SQL Server MVP
I am having problems locating much information on the specific differences
between SQL 2000 Personal Edition vs. 2000 Standard Edition. Does anyone have any
connection, RAM, process, size, etc limitation information on Personal Edition
(AKA Desktop Edition)?