Wednesday, March 7, 2012

Replication Newbe

Quick question – I have 2 SQL 2000 SP3 boxes. Server A is the distributor
Server B is the Subscriber.
If I make a change on server B why do those changes not replicate to server A
What am I missing
Also all sudden I have 2 of every table on the subscriber, can i just delete
the tables that don't contain the "rowguid"
HELP :-|
"BP" wrote:

> Quick question – I have 2 SQL 2000 SP3 boxes. Server A is the distributor
> Server B is the Subscriber.
> If I make a change on server B why do those changes not replicate to server A
> What am I missing
>
|||Have you definitely set up updatable subscriptions, or merge replication?
It sounds as if you haven't, or if you have, the queue-reader/merge agent
hasn't been run.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I'm not sure how this has happened Did you assign a different table name
or object owner for these tables? Also, what type of replication have you
set up?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment