I would like to ask some question and get some opinion regarding my problems. Things that could not be change: 1. SQL Server 2005 sitting in our server and SQL Server 2005 Compact Edition in our client PC. 2. I understand that SQL CE only works with merge replication. Things that still can be change: 2. 30 over tables/articles in one publication, and one of the table contains over 40millions of data (around 10GB). The problems: I tested out individual database as well as the rest of the database together in one publication Except the the HUGE table and everything was really smooth. When i added in the HUGE table, i cant generate snapshot. The snapshot agent just stopped on the server side. Even with the database alone in one publication, it is still the same outcome. The specification: 1. Pentium 4HT with 1GB of RAM. 23GB of free hard disk space 2. XEON 2.66Ghz with 4GB of RAM. 200GB of free hard disk space Both hardware system have failed. Is there any other way to work around this? Currently, i have been following the post below http://sql-server-performance.com/Community/forums/p/18277/104576.aspx#104576 but i don't think it is for SQL CE as i could not find the 'Subscriber has the schema and data' options. Thanks in advance!! #Update: I posted on msdn sql ce replication forum, but still did not get any reply. Hope to get opinion on this soon! Thanks and Have a nice day too.