Does Sql server 2000 work on Win XP (Home and Pro)

[DWorERP]

Both the developer edition and personal edition.

I have not been able to find anybody selling the personal edition.

Do both of them have the User interfaces to do the tasks?

thanks for you help.

 

[tlbroadbent]

SQL Server 2000 Personal Edition is not a separate product but rather a client component of SQL Server 2000 (included as part of the Enterprise and Standard Editions) that is designed to bring SQL Server 2000 functionality to non-server hardware, including workstations and laptops. Licensing of SQL Server 2000 Personal Edition is governed by the same rules as Enterprise and Standard Edition licensing.

Source:

http://www.microsoft.com/sql/howtobuy/personal.asp

Personal Edition will run on Windows XP (Home and Pro) but is subject to the licensing agreements noted above. The GUI tools are available because of the Enterprise or Standard Edition licensing.

Developer Edition will run on XP (Home and Pro). It includes the GUI tools.

The Desktop Edition (MSDE 2000) is included with a number of products, including Office XP Pro, Visual Studio .NET, etc. See the full list at the following link.

http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp

MSDE 2000 does not include the GUI tools.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.