Manage and Monitor Identity Ranges in SQL Server Transactional Replication
- by Yaniv Etrogi
Problem
When using transactional
replication to replicate data in a one way topology from a publisher to a
read-only subscriber(s) there is no need to manage identity ranges. However, when
using transactional replication to replicate data in a two way replication topology
-
between two or more servers there is a need to manage identity ranges…