Post reply

Skip error

  • January 26, 2006 at 6:36 pm

    #93186

    Hi,

      There's this function for skipping error in sql 2000 replication. I need to key in the error code in order for the replication to skip certain errors. Anyone got any idea where to get the list of errors available to be skip? Thanks in advance.

     

  • January 28, 2006 at 9:04 pm

    #617637

    The most common ones are:

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

    547:%ls statement conflicted with %ls %ls constraint '%.*ls'. The conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls.

    2601:Cannot insert duplicate key row in object '%.*ls' with unique index '%.*ls'.

    To skip this errors, create a new agent profile for the distribution agent and in the section of errors to skip add them separating them with :, for example:

    20598:547:

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

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