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

ID: Q240235

The information in this article applies to:

Microsoft SQL Server version 7.0

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 this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words:

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug