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)

Latency Issues

I'm seeing latency issues with a single user on MSDE. It appears that
data doesn't get persisted to the database for up to 30 minutes. What the
devil could be causing this? These are all new machines running the latest
service packs.
TIA
Tina
Hi
The application is not committing the data until very late. In a bad case,
where the connection to the server gets lost, SQL Server will rollback the
transaction as it is not committed. You can loose a lot of data though this.
In effect, there is a BEGIN TRANSACTION and somewhere further down the line,
maybe by chance (due to developer luck), there is a COMMIT TRANSACTION,
resulting in the data being committed.
Ask the developer to look at his application.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Tina Smith" <tb.smith@.earthlink.net> wrote in message
news:uGNS5ZdFFHA.2676@.TK2MSFTNGP12.phx.gbl...
> I'm seeing latency issues with a single user on MSDE. It appears that
> data doesn't get persisted to the database for up to 30 minutes. What
the
> devil could be causing this? These are all new machines running the
latest
> service packs.
> TIA
> Tina
>
sql