MSDE vs SQL Server

There is a project that a developer is suggesting 开发者_Go百科to use MSDE instead of SQL Server, I need to know the differences and limitations of MSDE to make sure it will be able to handle our project.

If I remember well MSDE ( Microsoft Desktop Engine or something like that ) is the precursor of SQL Server 2005, 2008 Express Editions. MSDE does not come with a management tool like SQL Server 2008 R2 Express, for example. Also MSDE comes with some constraints that in 2011 are antique ( 1GB for database or 1GB RAM for the server that hosts the MSDE). In conclusion , my advice is go with the latest SQL Server Express Edition.