SQL Server 2005 Compact Edition: The Little Engine That Can
January 16, 2007[From Developer.com]
Microsoft SQL Server 2005 Compact Edition (SQLce) is the newest version of Microsoft's mobile database solution. SQLce provides relational database functionality for mobile and desktop applications through a lightweight and easily distributable engine. Applications that need relational database capabilities but are not connected or only sometimes connected to a network can benefit greatly from SQLce.
The article continues at http://www.developer.com/db/article.php/3653821