>Has anyone used this in mobile applications? I am considering it for a handheld application that must work disconnected from the network and then sync back to the main SQL server database on the network. Just looking for recommendations, gotcha's etc. Or if anyone has an alternative they feel is better, I'm open to recommendations.
>
>thanks
>
>Alan Wyne

We just finished a mobile application using SQL Server CE. Alternative could be SQLLte - there is a nice article on CodeProject explaining how to set it up.

There are several limitations in SQLCE - you may want to check John Baird's article on the topic.