1. Can we create merge replication through script including distribution
database.
2. I am wondering if one of the box (either subscriber or publisher) goes
down, what are the steps needs to follow.
3. I created merge replication on the same box with two database and it
worked fine but when I create new stored procedure to table in publisher it
doesn’t synchronize to subscriber right away, we have to by force it through
management studio, is there any way or any script which I can run and it will
sync to subscriber right away.
4. What is the best practice in terms of performance to create distributer
database on same box or different box?
5. After creating new objects (Tables, Stored procedure, triggers) should I
have to write any command to replicate this objects into subscriber or it
will auto replicate into Subscriber.