• I don't like supporting these daisy chaining scenarios but I agree, it should work just fine.

    I don't consider it good repl design though because if something happens to the 1st subr you have to reinit both of them, including setting up a new publ on the orig subr. And if your DB is big then there goes the next couple days of your life.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE: