• The link to how you fix the IDENTITY is not working. Eere is the correct link.

    http://www.sqlservercentral.com/columnists/crego/repl/figure22.jpg

    I would also recommend against "fixing" the IDENTITY in this maner. When you do this the table is complete rebuilt. Click the little script icon to see what it is doing. A better option would be to set it as IDENTITY NOT FOR REPLICATION and then add the schema option of 0x04 to your publications.

    Bert