• Yes, you don't want to skip the error or it will just not replicate that command and then the stored procedure will not be there, or would not be updated. Of course this will only be true for the initialization of those objects. Once they are there it will still work to keep them in sync and they could be in the same publication. It is the initial create sequence that isn't maintained by replication which is what was causing you the problems, correct?

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot