help transactional replication
Dian
I don;t know how to explain my feelings about SQL Server replication ......
It is the most boring and strange stuff i ever met...
sometimes it works sometime it doesn't even i have same configuration that
works other times?
...
here is my probs:
i have 4 servers
server1 with SQL 2000
server2 with SQL 2000
server3 with SQL 2000
server4 with SQL 2000
server1 is distibutor and publisher
servers2 to 4 are subscribers with imediate update chanegs at subscribers
On server1 have 3 articles to replicate with transactional replication
these 3 articles is 3 tables each of them has clustered PK...
in the beginning replication did not work at all
i recieves messeges
DELETE statement conflicted with COLUMN REFERENCE constraint
'FK_prod_det_info_proddet'.
The conflict occurred in database 'xxx', table 'prod_det_info', column
'prod_det_id'.
(Source: server2 (Data source); Error number: 547)
----------------------------------------------------------------------------
-----------------------------------
The row was not found at the Subscriber when applying the replicated
command.
(Source: server2 (Data source); Error number: 20598)
----------------------------------------------------------------------------
-----------------------------------
but actually i was doing UPDATE on articles in Server1 and all of my
subscribers
interpreted it as DELETE/INSERT (deffered UPDATE) and it stoped
synhronization on servers 2 to 4
welldone SQL Server welldone !!!!
I remove clusered index and it begin work :)) welldone but i want CLUSERED
index !!!!
and i put it again - clusered index!
I read about sp_scriptdynamicupdproc which came with SP1 and i executed it
on my articles
and what a miracle - replication become work and when i UPDATE my articles
in server1
the update reaches and servers 2 to 4 (but even that i'm not sure if
sp_scriptupdproc helped me)
ok then !!!
Doing an UPDATE at server2(as expample) makes changes and replicate them to
server1
and then I recieves same messeges on agents for Server3 and server4:
DELETE statement conflicted with COLUMN REFERENCE constraint
'FK_prod_det_info_proddet'.
The conflict occurred in database 'sanita', table 'prod_det_info', column
'prod_det_id'.
(Source: server3 (Data source); Error number: 547)
----------------------------------------------------------------------------
-----------------------------------
The row was not found at the Subscriber when applying the replicated
command.
(Source: server3 (Data source); Error number: 20598)
----------------------------------------------------------------------------
-----------------------------------
same error at server4 no errors on server2 and server1
what is that nasty hell i am in ????? my hell is named SQL Server
replication
can some one help?
thanks