>
>SQL CE is certainly easier to deploy since it is strictly file based. I've worked with it a little, but am no expert with it.
>
>SQL Server, though a lot bigger footprint, takes care of itself. Recovery from things like machine or power failures is generally a non-issue, and if you use full logging and backup smartly you can also recover a database to a point in time in case your user has seriously screwed up their data.
>
>You can also easily make SQL server accessable from the internet for maintenance - It is a simple matter to teach a user how to open port 1433 on their firewall when you need it (and disable it when you don't!!).

Your points in favour of SQL Server are really helpful! And great to know there is someone so experienced with SQL Server here! I am sure I will have more questions as these project continues!