Difference between MSDE and SQL Server 2000

 Difference between MSDE and SQL Server 2000

S.No	MSDE	SQL Server 2000
1	Size: In MSDE database size limited to 2GB.	Size: In SQL Server database size limited to 1,048,516 TB1(1 Billion GB).
2	Performance: Performance of MSDE degrades when maximum number of concurrent operations greater then or equal to 8. Performance degradation is implemented with the help of SQL SERVER 2000 workload governor.	Performance: In SQL SERVER 2000, possible number of concurrent connections are 32,767.
3	OLAP and Data warehousing: MSDE does not provide OLAP and Data warehousing capabilities	OLAP and Data warehousing: MSDE provides OLAP and Data warehousing capabilities
4	Mail: MSDE does not have support facility for SQL mail.	Mail: MSDE supports facility for SQL mail.
5	Administrative Tools: MSDE doesn't have its own administrative tools. There are many third party tools, which provide administrative capability GUI.	Administrative Tools: SQL Server have administrative tools such as enterprise manager, Query analyzer or Profiler.

Note: MSDE(Microsoft Desktop Engine) is a cut down version of the SQL SERVER database and free, redistributable software.