Microsoft KB Archive/192488

= BUG: Dist Task Ignores Errors on Pre-creation Commands =

Article ID: 192488

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q192488



SYMPTOMS
The distribution task ignores any errors on pre-creation commands and attempts to proceed further with the sync operation, without reporting this error in the task history. Depending on the error on the pre-creation command, this may result in failures on the sync command, such as duplicate key errors or bcp-related errors.



WORKAROUND
Verify that the pre-creation command completes successfully if the distribution task fails on sync command. You can identify the last successful job based on job_id in the MSlast_job_info table at the subscriber. Manually run the pre-creation command and rectify any error causing condition before restarting the distribution task.



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5.

Additional query words: prodsql schema err ignored dist replication

Keywords: kbbug kbpending KB192488

-

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

© Microsoft Corporation. All rights reserved.