-
update inside trigger is not replicating
I have a following problem.
Table T is replicating from Publisher to Subscriber. Both servers are
Microsoft SQL Server 2005 - 9.00.2047.00.
On table T there is a trigger (update/insert) on Subscriber that does
updates on another table - O. Table O is replicated back to Publisher.
Trigger is firing, this is not a problem, but changes that are done on
table O are not replicated further. If I manualy update table O,
changes are replicating correctly.
Does anybody know about such problem?
-
Re: update inside trigger is not replicating
I was meaning to use sp_changedistpublisher to change the working directory.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
-
Re: update inside trigger is not replicating
On 9 Jan, 12:52, todi.gan...@gmail.com wrote:
> I have a following problem.
>
> TableT is replicating from Publisher to Subscriber. Both servers are
> Microsoft SQL Server 2005 - 9.00.2047.00.
>
> OntableT there is atrigger(update/insert) on Subscriber that does
> updates on anothertable- O.TableO isreplicatedback to Publisher.Triggeris firing, this isnota problem, but changes that are done ontableO arenotreplicatedfurther. If I manualyupdatetableO,
> changes are replicating correctly.
>
> Does anybody know about such problem?
Hi, I have the exact same problem. Did you ever find any solution for
this. I'm desperate for a solution.
Regards Martin
