SQL Server now decides that synchronization between the subscriber and publisher is more important than durability of a committed transaction and quietly issues a system delete...
Customized record locking is achievable in MS SQL Server CE - for an in-depth understanding go to Micro Soft's knowledge base and read the section (and subsections) on Locking.