Groups | Blog | Home
all groups > sql server replication > january 2006 >

sql server replication : strange replication


Hilary Cotter
1/26/2006 9:07:00 PM
Did you check the conflict viewer - they could be logged there if there were
conflicts?

--
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]

maxzsim via SQLMonster.com
1/27/2006 12:38:58 AM
Hi ,

I have set up queued updating at local server. i have managed to create a
customer and it got replicated over to the other site.

However, when i tried to modify some details of the customer or even delete
that customer. and when i start sychronize it shows that x commands has been
delivered. But when i check at the other end , the customer record still has
not been updated/deleted.

Appreciate ur kind advise

tks & rdgs

--
Message posted via SQLMonster.com
maxzsim via SQLMonster.com
1/27/2006 2:57:36 AM
Hi ,

How/Where can i check if there's any conflicts ? i have setup as txn
replication but dun see any view conflicts during right-click.

I thought it's only for merged replication ?

tks & rdgs

[quoted text, click to view]

--
Message posted via SQLMonster.com
Michael Hotek
1/27/2006 11:44:19 AM
Conflicts can occur for either merge or transactional with queued updating.
In 2000, you have to right click on the publication to get to the conflict
viewer.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

[quoted text, click to view]

Pranil
1/30/2006 7:31:27 PM
Did you do a snapshot initialization for this set up ? I had the same problem
and found that some of the replication system tables are not created unless a
snapshot initialization is done from the publisher to the subscriber. You can
do a quick check by looking for sys.MSreplication_queue in the subscriber
database. There won't be an error anywhere (that I know of) which indicates
that the system tables are missing.



[quoted text, click to view]
AddThis Social Bookmark Button