Hi,
I'm confused. I have bidirectional transactional
replication configured between 2 servers (sql server 2000
sp3). Same table is publisher and subscriber on both
servers.
Execution of:
sp_helpsubscription <publication name>
shows that loopback_detection is set to "No" on both
servers, and still, table changes are not being replicated
back, to the orginating server.
How is that posible? Is there any other way to prevent
changes to get back to the originating server?
Thanks,
OJ
It should be set to 1 or true for it to work.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"OJ" <anonymous@.discussions.microsoft.com> wrote in message
news:0e5701c4a656$16a33710$a401280a@.phx.gbl...
> Hi,
> I'm confused. I have bidirectional transactional
> replication configured between 2 servers (sql server 2000
> sp3). Same table is publisher and subscriber on both
> servers.
> Execution of:
> sp_helpsubscription <publication name>
> shows that loopback_detection is set to "No" on both
> servers, and still, table changes are not being replicated
> back, to the orginating server.
> How is that posible? Is there any other way to prevent
> changes to get back to the originating server?
> Thanks,
> OJ
Sunday, March 11, 2012
Bidirectional transactional replication question
Labels:
2000sp3,
bidirectional,
configured,
database,
microsoft,
mysql,
oracle,
publisher,
replication,
server,
servers,
sql,
table,
transactional,
transactionalreplication
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment