SQL Compact: Yet another SQL Server edition
Microsoft has just released SQL Compact, an upgrade of SQL Mobile that supports the desktop. Here's a white paper describing when to use Compact over Expression edition. Upshot? Application embedded database in SQL Compact. Lightweight, but full featured DB in Express Ed.
Not mentioned but I'd have to think that SQL Compact has a much nicer deployment story.