Post reply

What is the difference between SQL Server 2000 Standard verses Personal Edition

  • May 15, 2006 at 1:36 pm

    #112905

    What is the difference between SQL Server 2000 Standard Edition verses SQL Server 2000 Personal Edition? On our Production Server we have SQL Server Standard Edition 8.00.760 (SP3) installed. Recently, I installed SQL Server 2000 on our Test Server and the Product Version says SQL Server Personal Edition 8.00.760 (SP3).

    Thanks in advance, Kevin

  • May 15, 2006 at 1:55 pm

    #637996

    You can find a features comparison here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp

  • May 17, 2006 at 10:31 pm

    #638623

    Personal edition is the same as MSDE but with a copy of Enterprise Manager, Query Analyser, etc...  When you purchase SQL Server Standard/Enterprise you also receive media for Personal edition.  The idea is that you can have Personal edition on roaming laptops, etc so that your road users can have SQL Server and the associated tools for data on the run - you have your main server running Standard/Enterprise copy the data to the laptops via replication of some sort.

    So the main difference is the same as the difference between Standard & MSDE.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply