این قابلیتهای MSDE :
* Supports up to 2Gb RAM.
* 2GB database size limit.
* Five concurrent users or less is recommended.
* Supports up to 2 CPU on Windows NT or Windows 2000 box.
* No publishing for transaction replication.
* No Database Server Failover Support.
* No Full-text search.
* No GUI interface (there are no SQL Server Enterprise Manager, SQL Server Profiler, Query Analyzer, Database Upgrade Wizard, Index Tuning Wizard, Import and Export Wizards, and so on).
* No OLAP.
* No English Query.
* No SQL Books Online.
که تمام این قابلیتها در نسخه Enterprise کامل و حتی غیر قابل تصور است.