Change column width

• moorthy

  SSC Enthusiast

  Points: 159

  More actions

  December 30, 2003 at 4:55 am

  #59927

  Is there any tricks to change a column length in a table participating transaction replication? Is there any 'work around' without dropping & re-creating the articles?

  i am aware of adding a new column (sp_repladdcolumn) and dropping an existing column (sp_repldropcolumn)

  TIA

  Moorthy

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  December 30, 2003 at 7:09 am

  #488171

  Not directly.

  You can drop and then add the column with the new size with sp_repladdcolumn and sp_repldropcolumn.

  In this way there is no need to reinitialize the subscriptions.