Export (0) Print
Expand All

Comparing SQL Server Express with MSDE

SQL Server 2005

SQL Server 2000 MSDE is the predecessor to Microsoft SQL Server 2005 Express Edition (SQL Server Express), and is based on SQL Server 2000. If you are updating your applications to use SQL Server Express, you must consider the changes in feature support from MSDE to SQL Server Express.

The following table lists the limits that have been set for MSDE and SQL Server Express databases.

Limitation MSDE Limit SQL Server Express Limit

Concurrent workload governor (throttle)

Yes

No

Database size limitation

2 GB

4 GB

RAM support

2 GB

1 GB

SMP support

2 (or 1 if MSDE is run on Windows 98 or Windows Millennium Edition)

1

ms165672.note(en-US,SQL.90).gifNote:
In MSDE, the Workload Governor (also known as the throttle) caused performance limitations as the number of concurrent users increased. SQL Server Express does not have a Workload Governor.

The following table lists the changes in feature support between the products.

Feature Area Supported in MSDE? Supported in SQL Server Express?

Merge Replication

Yes

Yes, as a Subscriber only

Transactional Replication

Yes, as a Subscriber only

Yes, as a Subscriber only

Snapshot Replication

Yes

Yes, as a Subscriber only

SQL Server Profiler

No

Yes only if another edition of SQL Server 2005 is installed on the same machine as SQL Server Express.

SQL Server Profiler is not installed with SQL Server Express.
ms165672.note(en-US,SQL.90).gifNote:

Database Engine Tuning Wizard

No

No

SQL Server Agent

Yes

No

Active Directory registration

No

Yes

For more information about MSDE and SQL Server Express, see "Upgrading MSDE to SQL Server Express at MSDN library.

Community Additions

ADD
Show:
© 2014 Microsoft