Adding MergeArticles with DMO

• psullivan

  SSChasing Mays

  Points: 604

  More actions

  December 28, 2002 at 2:46 pm

  #81372

  Hey all this is related to my topic on replication system tables. Through working on this I have come to need to add a table to a current merge publication. So far this si what I have come up with, I think I am way off here..need help.

  dim oSrv, strServer

  strServer = "server"

  set oSrv = CreateObject("SQLDMO.SQLServer")

  oSrv.Connect strServer, "sa", "sapassword"

  'add to replications

  set rPub = oSrv.Replication.ReplicationDatabases("DTS_Store").MergePublications("DTS_Store")

  rPub.BeginAlter()

  set mArt = rPub.MergeArticles

  mArt.Add("test")

  rPub.DoAlter()

  oSrv.Disconnect

  oSrv.Close

• December 31, 2002 at 8:00 am

  This was removed by the editor as SPAM

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  December 31, 2002 at 8:17 am

  #445340

  Not quite a duplicate thread, I posted some basic how to code in the related thread here:

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8994&FORUM_ID=7&CAT_ID=1&Topic_Title=Replication+of+System+Tables&Forum_Title=Replication

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter