Is SQL Server 2005 Express the new version of MSDE?

Hi,
Is SQL Server 2005 Express the new version of MSDE once it's final? I assume
it will have similar restrictions -- 10 connections, etc.
Thanks,
Sam
Yes, SQL Server 2005 is the successor to MSDE. It will still be free, it
will still be distributable, and licensing (so I hear) will be /much/
simpler.
No, there will not be a 10 connection restriction, and there never was in
MSDE, either. There was a workload governor that kicked in when you go over
8 simultaneous (5 user/3 system) *workloads*, which are not the same as
connections. Please read
http://msdn.microsoft.com/library/en...r_sa2_0ciq.asp
There is no such governor/throttle technology in SQL Server 2005 Express.
As for other differences between MSDE 2000 and SQL Server 2005 Express:
SQL Server 2005 Express will add a currently not available graphical
management tool, called Express Manager (its features will be a subset of
those found in Management Studio). Maximum database size has been increased
from 2 GB to 4 GB (and still does not count log space toward the limit).
SQL Server 2005 Express is now limited to 1 GB RAM and 1 CPU (MSDE allowed 2
GB RAM and 2 CPUs). SQL Server Agent and DTS runtime are no longer
included, and there is limited replication support. Currently, SQL Server
2005 Express is only supported on 2000, XP, and 2003. I don't believe the
consumer 9x line (95, 98, Me) will be supported.
If I missed anything, I'm sure someone will swoop in and clean up. You can
also see:
http://msdn.microsoft.com/library/en...seoverview.asp
http://www.aspfaq.com/
(Reverse address to reply.)

> Is SQL Server 2005 Express the new version of MSDE once it's final? I
assume
> it will have similar restrictions -- 10 connections, etc.
|||Sam,
Bascially the answer is yes, but the restrictions are different. SQL Express
uses limitation of database size and number of processors used but does not
use the workload governor.
Ginny Caughey
..Net Compact Framework MVP
"Sam" <sam@.globalwebcentral.com> wrote in message
news:euGLloeiEHA.1040@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Is SQL Server 2005 Express the new version of MSDE once it's final? I
assume
> it will have similar restrictions -- 10 connections, etc.
> Thanks,
> Sam
>