Which SQL Server

[Igor]

On Win2000 or Win2003 you can use SQL Server 2000 Desktop Edition. On WinXP
you must use only SQL Server 2000 Developer Edition.
Which SQL Server 2005 I can use on WinXP?

[Erland Sommarskog]

Re: Which SQL Server

Igor (igor@nesalji.h r) writes:

On Win2000 or Win2003 you can use SQL Server 2000 Desktop Edition. On
WinXP you must use only SQL Server 2000 Developer Edition.

In fact you can use all editions save Standard and Enterprise Edition of
SQL Server 2000 on Windows XP. (I am not 100% sure about Workgroup Edition,
but it would not make sense if you could not.)

Which SQL Server 2005 I can use on WinXP?

All editions but Enterprise. That is, even Standard Edition.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[dmarkle]

Re: Which SQL Server

I'm assuming here that you're a developer writing code on test
databases on your workstation. In that case, you'll want to use
Developer Edition. It includes just about all of the features and
optimizations inherent in Enterprise Edition, but runs on Windows XP.

-Dave

http://www.markleconsulting.com

Igor wrote:

On Win2000 or Win2003 you can use SQL Server 2000 Desktop Edition. On WinXP
you must use only SQL Server 2000 Developer Edition.
Which SQL Server 2005 I can use on WinXP?