Transactional replication

  • I am implementing Transactional replication in 2005.Do i need to turn on or off "NOT FOR REPLICATION" option for identity columns?

    Thanks in advance

  • You dont really need to change this as "Not for Replication" ensures that there is no new ID created and instead allows replication pass the ID value from publisher to subscriber, in fact this setting allows you to make sure that the data is in sych at both the ends.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply