|
Home > Archive > MS SQL Server Replication > September 2005 > Replication Newbe
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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
>
| |
| Paul Ibison 2005-09-19, 8:24 pm |
| 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)
| |
| Paul Ibison 2005-09-19, 8:24 pm |
| 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)
|
|
|
|
|