I have setup a transactional replication and I want to be able to skip errors
2627 and 20598 due to project requirement....
The replication distriburtor job command is as follow: ( from jobs/step (
run agent ))
-Subscriber [SQ01] -SubscriberDB [db_Rep] -Publisher [SQ03] -Distributor
[SQ03] -DistributorSecurityMode 1 -Publication [VisitsUpdates] -PublisherDB
[testdb] -Continuous -SkipErrors 2601;2627;20598

I also set the distributor job to run on the "Continue on data consistency
errors" agent profile.

I am still getting the error
The row was not found at the Subscriber when applying the replicated command.

( Error 2627! )

I restarted the distribution agent job but still getting the same error
above. I already spent hours on this! please help

Using sql server 2008 sp1 on all servers.

Thank you


--
dev 2005

BTW: there are no triggers on the subscriber database.
--
dev 2005


"CEN05" wrote:

BOL is inconsistent; on the page documenting the distrib executable,
it says the -SkipErrors parameter is a *colon* separated list, while
on the page titled "Skipping Errors in Transactional Replication", it
says it's a *semi-colon* separated list. Try changing the semi-colons
in your agent to colons and see if that helps.
--
Ben

On Mar 2, 1:51*pm, CEN05 <CE... (AT) discussions (DOT) microsoft.com> wrote: