Problem on Transactional Repliation

  • I have a ssubscription marked with an error.

    The error is:

    The row was not found at the Subscriber when applying the replicated command.

    IS there any way I can find out which record is causing the problem?

    Can I look in the distribution database?

    Thanks

  • When you right click on the subscription and choose "Error Details" does it show you the enough info about the row in error? It has been a while since I had this problem, but I thought the Error Details pane showed the key of the row in question.

  • No,

    There are no error details. The message above is all that I have.

  • Turn on logging for the distrib agent. Use -outputverboselevel 3 -output c:\repl.txt. Might have to double check the syntax, but that is close.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply