PRB: Immediate Updating Subscriber Option Involving Different SQL Server Versions (271727)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
- Microsoft SQL Server 7.0
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 "msrepl_tran_version" 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.
| Modification Type: | Major | Last Reviewed: | 10/16/2003 |
|---|
| Keywords: | kbprb KB271727 |
|---|
|