Microsoft KB Archive/240235

= BUG: "Implementing Nonpartitioned, Bi-directional, Transactional Replication" Sample in Books Online Contains Errors =

Article ID: 240235

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q240235



BUG #: 56182 (SQLBUG_70)



SYMPTOMS
The Implementing Nonpartitioned, Bi-directional, Transactional Replication sample in SQL Books Online does not correctly set up bi-directional replication.



CAUSE
The script provided does not use the correct values for the following parameters:
 * @loop back_detection
 * @allow_sync_Tran
 * @update_mode

Additionally, you must have a timestamp data type column in the publishing table.



WORKAROUND
To configure nonpartitioned, bi-directional, transactional replication, set the loop back_detection parameter in the sp_add subscription procedure to "True". In order to set the @loop back_detection parameter to "True", follow these steps:
 * 1) Add a timestamp column to the publishing table.
 * 2) Set the @allow_sync_Tran parameter in the sp_add publication procedure to "True".
 * 3) Set the @update_mode parameter in the sp_add subscription procedure to "sync Tran".



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbpending KB240235

-

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

© Microsoft Corporation. All rights reserved.