• Charles and Roy,

    I have two small questions for you. These answers are very important for me.

    Qu: 1:If alter command is replicated then any schema change would not require any reinitialization of subscriber. So what are the instances when do we still need reinitialization?

    Qu: 2:Some days back I read an article which tells how to delete the rows from publisher but not from subscriber. This tells to create one SP on publisher and put the logic of deleting rows in it. Now replicate this and manually delete the logic of deleting rows from the SP at subscriber end. But I feel that when the SP runs at publisher end then the log for deletion should traverse to subscriber and would delete the rows. Does SP run then logs generate only for sp run and not for deletion of rows?

    Thanks in advance.

    -Lk