• MSrepl columns are added by replication, the problem is that it in this case the publisher doesn't expect to be inserting a value into that column. This happened because you did the restore rather than a snapshot. Delete the column from the subscriber and see what happens.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/