sql server replication: Hello,

I am trying to perform 2 way replication in SQL 2000.

SERVERA = OrdersTable -> I want data to replicate to this
server from SERVERB on UPDATE only.
SERVERB = OrdersTable -> I want data to replicate to this
server from SERVERA on INSERT only.

This is what I have done.
I created a publication on SERVERA and in the article
properties, I checked only INSERT.
Then I created a push subscription to SERVERB.

I then created a publication on SERVERB and in the article
properties, I checked only UPDATE. Then I created a push
subscription to SERVERA.

Is this the correct way to achieve my goal?

I don't think so. First are you using merge replication? It sounds like you are. I think you are talking about the merging
changes tab options on the articles properties tab.

This verifies that a merge agent has rights to insert, update or delete. So you can have 1 pull subscriber which can do all three depending on his/her rights, and another that can't, or can have a subset or rights.

bi-directional transactional replication might be the way to go with this as you can write custom stored procedures to incorporate your business logic.


Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html