• emailt@gmail.com - Wednesday, February 7, 2018 8:14 AM

    We have had the same issue (SQL Server 2012, SP3) and we think it's because of this:

    The NOT FOR REPLICATION option is specified by default for foreign key constraints and check constraints; the constraints are enforced for user operations but not agent operations.


    Source: https://docs.microsoft.com/en-us/sql/relational-databases/replication/administration/frequently-asked-questions-for-replication-administrators

    Also some further information about IDENTITY columns in a replication scenario:

    https://docs.microsoft.com/en-us/sql/relational-databases/replication/publish/replicate-identity-columns

    Note: Three year old thread.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/