Bi-Directional Transactional Replication - Problem -- sql server replication

senthilprabu
8/26/2005 9:27:21 PM

Two Servers,

1st 2nd
database a -------> after replication a'
b' <------- after replication b

on 1st server a is replicated to 2nd
on 2nd server b is replicated to 1st

I tried with merge replication it is working fine.But if i tried to use
transactional replication it give some error like "access
violation".Using tansactional replication is it possible.plz help me to
slove this problem.

Regards,
Senthil prabu R

Hilary Cotter
8/27/2005 5:55:59 AM

When you used sp_addsubscription, did you set @loopback_detection=true?

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

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

sql server replication : Bi-Directional Transactional Replication - Problem