• Many thanks for your reply.

    We only have one subscriber.

    What I do not understand is that since our transactional replication is one way (no updating at the subscriber), then why we need to have different identity ranges for an identity column in publisher and subscriber? The identity values are being generated at the publisher and these sames values are being inserted in the tables at the subscriber (identity columns at the subscriber has NOT FOR REPLICATION property set to YES).

    Could you please let me know why we need separate identity ranges at pubsliher and subscriber when the identity values are only being generated at the publsiher?

    Thanks in advance.