MSDE 2000 vs SQL express 2005 ??

Dear all,
We are starting a new developmement of our supervisiob system that will run
uner vista and we will use VS 2005 as a development platform ..
Based on that we need to select proper local database for our local data
archiving.
For that I will certainly us SQL express advance feature edition but some
say that there are connection limitation ?
As far as Icould read around, the only limitation there is is the 4GB
database sizte, 1 single processore handling, and 1GB of RAm for cachin
querries.
I did not get answer that sql express as a limitation in connection, is
there ?
Next I have heard also as an SQL personnal edition version.. Is it the MSDE
base on 2000 ? if its the case then it is not supported under Vista, si my
choice will be explain clearly then..
Thnaks for clarification and comments .
Regards
Serge
MCAD.NET
Thanks andrea, its clear now
"Andrea Montanari" wrote:

> hi Serge,
> calderara wrote:
> then you can only go for SQLExpress sp2 (not yet released)..
>
> tere aren't.. SQLExpress (as MSDE as well) does not include a component to
> limit connections.. it is limited as you already noticed..
> nope
>
> SQL Server Personal edition is based on SQL Server 2000 code base..
> regards
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>
>
|||Hello,
Perhaps you should also look "out-of-the-box" and take a look at some other
free database systems that do not impose these ridiculous limits such as
1cpu and no SQL Agent.
Primarily, PostgreSQL and Firebird.
"calderara" <calderara@.discussions.microsoft.com> wrote in message
news:49AE1207-0D8F-4166-8B8E-7FF970F39212@.microsoft.com...[vbcol=seagreen]
> Thanks andrea, its clear now
> "Andrea Montanari" wrote: