There are two SQL server 2008 editions. Compact & Express.
Compact
It is build for standalone and occasionally connected applications for mobile devices, desktops, and web clients on all Microsoft Windows platforms.
Express
It is ideal for learning and building desktop and small server applications and for re-distribution by ISVs.
Thanks!
