Re: Transactional replication - update does not follow row filter rules

Tech-Archive recommends: Fix windows errors by optimizing your registry



Thanks Paul

I'll take a look and post back.

Cheers

Ian

Paul Ibison wrote:
Ian,
this seems very odd. Let's confirm that the command being executed really
contravenes the view used to filter the article. For this you could use
sp_browsereplcmds, logging of the error on the distribution agent and check
the text of the synchronization view.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

.



Relevant Pages

  • Re: Snapshot Replication failing
    ... > You have updated the Publisher property 'working_directory' ... > Then I issued the following command: ... >> Rgds, ... >> Paul Ibison ...
    (microsoft.public.sqlserver.replication)
  • RE: Interop.SQLMERGXLib.dll
    ... command that I've launch is: ... .dll was loaded, but the DllRegistreServer entry point was not found. ... > Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Centralized Subscriber - MSIns and MSUpd stored procedures shared access
    ... Am not really sure of the implementation of SQL option in ... the update and delete command, in which case the stored procedures won't be ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot Replication failing
    ... "Paul Ibison" wrote: ... >> And I got a success reply: ... >> You have updated the Publisher property 'working_directory' ... >> Then I issued the following command: ...
    (microsoft.public.sqlserver.replication)
  • Re: Row not found at subscriber
    ... Could using immediate updating vs. queued ... I didn't actually run the command but I did query the database for the ... "Paul Ibison" wrote in message ...
    (microsoft.public.sqlserver.replication)