The -skipperrors Distribution Agent parameter for SQL Server 2000 may skip more commands than expected (896609)


The information in this article applies to:

  • Microsoft SQL Server 2000 Desktop Engine (MSDE)
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Enterprise Evaluation Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Standard Edition

SYMPTOMS

The Distribution Agent may skip all the transactions in a batch and all the commands that correspond to the transaction if all the following conditions are true:
  • A subscription to a transactional publication contains articles that have user-defined triggers. These triggers are defined at the subscriber, and the triggers are not marked as "NOT FOR REPLICATION".
  • You are using the -skiperrors Distribution Agent command line parameter. Commands that fail with errors that you have specified are skipped.
  • A SQL error occurs at the subscriber within the scope of the execution of a user-defined trigger. The SQL error that occurs is supposed to be skipped, as described in the second bullet of this list.

CAUSE

This behavior occurs because SQL Server rolls back the transaction and ends the batch if a SQL error is encountered within the trigger.

Note This behavior does not occur when a RAISERROR error message is thrown within a trigger.

RESOLUTION

Do not use the -skiperrors Distribution Agent parameter when one or more tables that are defined to a transactional publication have user-defined triggers associated with them at the subscriber.

STATUS

This behavior is by design.

MORE INFORMATION

For more information the -skiperrors Distribution Agent parameter, click the following article number to view the article in the Microsoft Knowledge Base:

327817 Use the "-SkipErrors" parameter in Distribution Agent cautiously

For more information, see the "Skipping Errors in Transactional Replication" topic in SQL Server 2000 Books Online.
Modification Type:MajorLast Reviewed:5/10/2005
Keywords:kbtshoot kbprb KB896609 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.