How to alter a primary key on a Replicated Table in SQL Server 2008

• Aspet Golestanian Namagerdi

  SSCarpal Tunnel

  Points: 4444

  More actions

  May 16, 2013 at 3:23 pm

  #277693

  We have a table in Sql Server 2008 R2, which has been (Transactional Replication) replicated to two subscriber. We need to increase the size of primary key column from char(14) to char(28).This specific article is part of publication that includes other articles.

  I fallowed the following steps and it wroked fine.

  1- Remove that article from publication

  2- Apply the changes on primary key on publisher and subscribers

  3- Re-Add article to publication

  When I checked the web,I noticed that many people were talking about fallowing steps:

  1- drop the subscription

  2- drop the article

  3- modify the table

  4- add the article

  5- add the subscription

  Do I need to drop the subscription?

• Neeraj Dwivedi

  SSCertifiable

  Points: 6768

  More actions

  May 17, 2013 at 8:44 am

  #1616217

  In the Transitional Replication Schema Changes are propagated when Distribution agent runs.

  You do not have to drop subscription.

  Read through this.

  http://msdn.microsoft.com/en-us/library/ms151870(v=sql.90).aspx