• Hey,

    Thanks loads for your help with this.

    I took the script that table diff created. I ran it at the Subscriber to insert the missing records..

    ...and Replication....

    Did not complain or grumble it just continued working happily!!!

    Before seeing your last reply about switching off the check constraint i decided to delete the records from that table(the rest of the tables were manual identity ranges) at the Publisher that I couldnt insert at the subscriber and it again happily continued without a whimper or murmur!!

    So there you go... non convergence issues use tablediff generate the script to insert the missing rows.. and insert them at the side that is missing the data.

    All working as hoped without any problems.

    Thanks again,

    Antony

    Time to make a change