Define an Identity Column

Question

Dear Friends,
Can anybody describe this?
In the table design view of the Ms SQL Server, when you want to set a column as an identity, you can view three options like No / Yes / Yes (Not for Replication). So, what does mean by “Not for replication”? What is the difference between Yes and Yes (Not for Replication)?

Josip Majic · Answer

Yes (Not For Replication) means that when you do the replication (synchronization), your identity column will not grab and increment a new value in the subscriber table.