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

The information in this article applies to:

Microsoft SQL Server 7.0

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:

Add a timestamp column to the publishing table.
Set the @allow_sync_Tran parameter in the sp_add publication procedure to "True".
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.

Modification Type:	Major	Last Reviewed:	10/16/2002
Keywords:	kbBug KB240235