What's the "Not For Replication" setting?

The "Not For Replication" setting for identity columns allows replication to pass the ID value from the publisher to the subscriber without the subscriber creating a new ID.  Since identity columns will always generate a new number when records are inserted, this setting allows you to ensure the values on both your publisher and subscribers stay in synch.

Reference link:http://www.mssqltips.com/tip.asp?tip=1274

原文地址:https://www.cnblogs.com/liunatural/p/1436328.html