replication

• bruce_reid

  SSCrazy

  Points: 2419

  More actions

  June 30, 2003 at 8:39 am

  #81089

  Hi,

  I need some help with replication. I am new to DBA position in my company.We have replication betwwen 4 servers.we are getting the data into server 4 from servers 1,2 and 3.

  we have the table Xxxx in all the 4 servers. Now we are going to add two columns to the table. basiacally i dont know which replication they are using already and which server is a publisher and which is subscriber,how should i know all the details.If i wanted to add the two columns what should i do with the existing replication? can i modify it with some procedure or should i recreate the new replication. please help me in this issue.

  Thanks..

• fromnaija

  SSCrazy

  Points: 2876

  More actions

  July 1, 2003 at 6:29 am

  #463755

  Looks like you have merge replication set up. Your server 4 is the subscriber and your server 1, 2, 3 are the publishers. Run this at each of the server to find the db that have replication set up in them -- sp_helpreplicationdboption.

  Check sp_repladdcolumn and sp_repldropcolumn for adding or dropping columns from your publications.

  Hope this helps.

  
  Joseph