SQL Server Compact Edition RC1 Released
This is what was formerly known as SQL Server Everywhere. If you need a lightweight database for your Smart Client applications, then you should definitely check out SQLCE. One of the great things about SQLCE is that you can deploy it as a private assembly. This means no admin privs to deploy a local database using ClickOnce!