Latest version of MSDE

What is the latest version of MSDE (and SQL Server)
that I can install for a client that uses Windows XP ?
SQL Server 2000 SP3 ?Originally posted by Karolyn
What is the latest version of MSDE (and SQL Server)
that I can install for a client that uses Windows XP ?

SQL Server 2000 SP3 ? http://www.microsoft.com/sql/msde/downloads/download.asp|||you're early today !
happy new year !

Is there some significant performance increase
between SQL Server 7 and SQL Server 2K ?
'Cause I've done all my tests on SQL Server 7 and MSDE 7
and I was'nt impressed by the performances
(that we're comparable with thoses I had with Sybase)|||Originally posted by Karolyn
Is there some significant performance increase
between SQL Server 7 and SQL Server 2K ?

Cant comment much on that !! have not worked much on SQL Server 7.0|||Performance increases - New datatype(table), views (ability to index and partition), index enhancements such as ability to index a computed column and index creation, how text/ntext/image are stored ...

Read this article:

link (http://msdn.microsoft.com/msdnmag/issues/0800/sql2000/default.aspx)|||You left out UDFs?|||That was referencing performance increases - udfs offer reusability,maintainability and extensibility ... Anyway, all the benefits of sql server 2000 are included in the link.|||Also ... don't mention udfs for a while after the permissions bug :-)|||yeah, brett, you almost started it again|||Originally posted by rnealejr
Also ... don't mention udfs for a while after the permissions bug :-)

hey !!! what was that ??|||well, rdjabarov and blindman got at it again when an m$ bug was being discussed. apparently neither one of them can hold their waters :-)|||?? :confused: ??|||hey, it's simple:

one is a man, and another...is also a man...does it make sense?? :-)|||I mean ... can you point me to the battleground ... i would like to see the war for myself :D|||just read from the beginning (http://www.dbforums.com/t977030.html)