Transactional Replication - How to remove orphaned articles?

• Roger Sabin

  Ten Centuries

  Points: 1022

  More actions

  January 27, 2015 at 1:14 pm

  #294746

  We are runnning on SQL Server 2012 SP1 + CU9.

  I have found some articles with no publication in our transactional replication.

  For example, running this:

  select p.publication,

  a.publication_id,

  a.article

  from dbo.MSArticles as a

  left outer join dbo.MSpublications as p

  on a.publication_id = p.publication_id

  shows this:

  NULL1org_Community

  NULL3org_Community

  Purchasing to EDW5org_Community

  NULL1org_Division

  NULL3org_Division

  Purchasing to EDW5org_Division

  How can I get rid of the articles that are not part of a publication?

  I can't use sp_droparticle because it requires a publication which these articles do not have.

• lmarkum

  SSCertifiable

  Points: 7989

  More actions

  January 27, 2015 at 5:00 pm

  #1773539

  The link below says you cna run this at the Publisher OR the Subscriber to remove replication objects.

  https://msdn.microsoft.com/en-us/library/ms188734%28v=sql.110%29.aspx