Transaction Replication - How does the Identity range work.
Hi All, I am setting up a transactional replication for MS SQL 2019. The team is using Identitiy columns as the PK on the tables. I know they are a issue when a failover happens. I would like to set my Identity Range for my Publisher to be from 1 to 2 lakhs and in case of failure the subscribr should start from 2 lakhs. Is this possible if yes can anyone help in providing a sample code to do the same.