• Roy

    Thanks for the ideas.The following needed to be done to over come the issue.

    1. SkipError 2627

    2. On the Publisher i had to run sp_addsubscription with @sync_type = N'replication support only'; This did the magic.

    The default is 'Automatic' which did not like the table being there.

    Also,

    3. The structure need to exist at the destination and the data be pre-populated. Then any further DML will be replicated.