Overview of SQL Server 2005 Express on MSDN

Rajesh George from the SQL Server Express (SSE) team has posted a nice, clear article on MSDN with an overview of the main features and differences of SQL Server 2005 Express.   You should walk away with a good understanding of how it differs from the standard SQL Server 2005 product as well as how it differs from MSDE (SQL 2000).

I have always been a big advocate of using MSDE, where appropriate.  I have spoken about it at various conferences and worked with clients to migrate from JET (even skeptical ones). I am currently involved in several projects with SQL Server 2005 Express and the story is only getting better.

Using MSDE or SQL Server Express  is a great to avoid the issues involved (and there are many) in moving from an MDB to SQL Server when your application (or your clients) "grows up" - and doesn't cost you anything.  Moreover, taking advantage of  MSDE or SSE allows you to design and implement your database and data access code the right way, from the very start

.