Article ID: 240235 - Last Review: October 16, 2002 - Revision: 1.1

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

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

This article was previously published under Q240235

BUG #: 56182 (SQLBUG_70)

Expand all | Collapse all

SYMPTOMS

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

Back to the top

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.

Back to the top

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".

Back to the top