What's the real difference between SQL Server and the desktop version?

[bigfoot]

What's the real difference between SQL Server and the desktop version? I wanted to load it on an XP machine. Does the desktop version have everything that the "real" version has.

The desktop version came on another CD with SQL Server.

 

[Zekske]

The full version can't be installed on a desktop OS, the dev
elopper or desktop edition has all the feature's of SQL and can be installed on a desktop OS.

Keep in mind that a desktop OS has a maximum of 10 client connections.

Regards

 

[bigfoot]

So the full version needs Windows 2(something) SERVER?

And it won't work on Win XP Pro, huh?

 

[tlbroadbent]

Check with Microsoft.

Operating Systems Supported by the Editions of SQL Server 2000

http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_7eur.asp

Features Supported by the Editions of SQL Server 2000

http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_1cdv.asp

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

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