I am not a replication expert but Merge replication is the only form that allows changes on both sides. I
-Mike
>Hi,
>
>This is my scenerio.
>
>SQL Server A and SQL Server B must have transactional replication inplace so that when tables data changes in Server A, Server B will have the same data created. And Vice Versa.
>
>My Question: I want to ensure that I am able to replicate changes made to either Server A tables or Server B tables if either server goes down.
>
>Do I set up transactional replication and merge replication ?
>
>
>Thanks,
>
>Alvin