Microsoft KB Archive/896609

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

Article ID: 896609

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Desktop Engine (Windows)
 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Enterprise 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 &quot;NOT FOR REPLICATION&quot;.
 * 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 &quot;-SkipErrors&quot; parameter in Distribution Agent cautiously

For more information, see the &quot;Skipping Errors in Transactional Replication&quot; topic in SQL Server 2000 Books Online.

Keywords: kbtshoot kbprb KB896609

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.