smpross
asked on
Difference between MSDE and Microsoft SQL Server Personal edition
Hi All,
Is there a difference between The Microsoft SQL Desktop engine and Microsoft SQL Server Personal Edition. I can not seem to find the Microsoft SQL Personal Edition for sale anywhere. Does it come with SQL Server standard edition. If so, what are the licensing requirements. Thanks.
Scott
Is there a difference between The Microsoft SQL Desktop engine and Microsoft SQL Server Personal Edition. I can not seem to find the Microsoft SQL Personal Edition for sale anywhere. Does it come with SQL Server standard edition. If so, what are the licensing requirements. Thanks.
Scott
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also:
SQL Server 2000 Personal Edition is not a separate product but rather a client component of SQL Server 2000 (included as part of Enterprise and Standard Editions), designed to bring SQL Server functionality to nonserver hardware, including workstations and laptops. SQL Server Personal Edition can be installed on any client device to be used in conjunction with the server software. Licensing is governed by the same rules as Enterprise and Standard Edition licensing.
SQL Server 2000 Personal Edition is not a separate product but rather a client component of SQL Server 2000 (included as part of Enterprise and Standard Editions), designed to bring SQL Server functionality to nonserver hardware, including workstations and laptops. SQL Server Personal Edition can be installed on any client device to be used in conjunction with the server software. Licensing is governed by the same rules as Enterprise and Standard Edition licensing.
http://www.microsoft.com/sql/howtobuy/default.asp
Licensing FAQ:
http://www.microsoft.com/sql/howtobuy/faq.asp
From this whitepaper: http://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp
SQL Server 2000 Personal Edition
SQL Server 2000 Personal Edition is ideal for mobile users who spend some of their time disconnected from the network but run applications that require SQL Server data storage, and for stand-alone applications that require local SQL Server data storage on a client computer.
This edition is functionally equivalent to the Standard Edition, with the following exceptions:
• It includes a concurrent workload governor that limits its scalability; performance degrades when more than five Transact-SQL batches are executed concurrently.
• It can use a maximum of two processors in an SMP computer (only one processor if running Windows 98 or Windows Millennium Edition).
• It cannot act as a transactional replication publisher (subscriber only).