Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-14 : 11:19:13
|
Narendra Bisht writes "Hi,
I have 3 servers called ClientA, ClientB and ClientX.
ClientX is my Central Subscriber. ClientA and ClientB are my Publishers.
ClientA -------> ClientX <-------ClientB
(Central Subscriber) I have set Transactional Replication, with immediate updating and queued updating subscriber options.
I want to Replicate a table which is on both the clients to my Central Subscriber(ClientX). There is no problem as far as replicating data to Central Subscriber(ClientX) from both the clients but when i m trying to update the same data which was replicated from my clients at the Central subscriber(ClientX), it is updating my one client from where the data came but when i try to update the data of second client at Central subscriber(ClientX) the update is not working and moreover it is deleting the record from the Central Subscriber(ClientX) for the second client. I have tried all the options but couldn't figure out the exact problem. I m very badly looking for ur help." |
|
|
|
|
|
SQL 2000 Replication