>>We want to set up 3 different servers with MSDE and sync them using replication. Using merge replication, is it possible to have changes distributed from all 3 servers. I guess what we are asking is if it is possible for MSDE to be both a subscriber and a publisher.
>
>Don't know if you can do that with MSDE or not, but you can with SQL Server. Even then, it didn't work very well, and if you get out of sync, it's a royal mess to try to get synched back up. We gave up on letting SQL do it, it was just too fragile.
I have merge replication working between two servers over a WAN without too many problems. As Fred pointed out, the initial snapshot is a problem and the built-in tools are insufficient. I think depending on your requirements and with enough 3rd-party tools, you can get it to work well enough for many situations. red-gate.com has some tools to validate and "fix" replication when SQL Server messes it up. The major complaint I have is that SQL Server doesn't seem very good at detecting when things get out of sync.