Microsoft KB Archive/271727

= PRB: Immediate Updating Subscriber Option Involving Different SQL Server Versions =

Article ID: 271727

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q271727



SYMPTOMS
In SQL Server replication, starting with Microsoft SQL Server version 7.0, there is an option for subscribers of either Transactional or Snapshot replication to update the subscribed data while simultaneously updating the publishing data through a two phase commit protocol.

Please note that the requirements for creating publications with the Immediate Updating option has changed in SQL Server 2000. Now, there is even higher scalability through the Immediate Updating option of queued subscribers.

For SQL Server 2000, a uniqueidentifier column with the specific name &quot;msrepl_tran_version&quot; is required instead of the timestamp column required by SQL Server 7.0.

The uniqueidentifier column is automatically added to a table when the publication article is created and it is used to track the row version.



CAUSE
SQL Server 7.0 publications with Immediate Updating Subscribers should be subscribed only by SQL Server 7.0 Subscribers.

SQL Server 2000 publications with Immediate Updating Subscribers should be subscribed only by SQL Server 2000 Subscribers.

Additional query words:

Keywords: kbprb KB271727

-

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

© Microsoft Corporation. All rights reserved.