modify replicated table

• Tania Guyer

  SSC Enthusiast

  Points: 113

  More actions

  May 1, 2005 at 4:45 am

  #88900

  Hi,

  is it possible to modify table ( add column, change datatype ) that is replicated and don't delete subscription/publication before it ?

  10x

  Tania

• adamcrv

  Hall of Fame

  Points: 3056

  More actions

  May 1, 2005 at 10:20 pm

  #556203

  Because you are altering the actual articles (tables) I think you would have to reinitialize the subscribers

  Adding articles check BOL for these

  sp_addmergearticle

  sp_repladdcolumn

  sp_rename

  eg you can rename indexes etc

  sp_rename '[dbo].[TblGblBlahLevels].[111TblBlahImprLevels_PK]', 'a111TblBlahImprLevels_PK', 'INDEX'

  GO

  HTH

  hopefully another can confirm what i have shown here for you..

  Cheers

  Adam

  
  ------------------------------
  Life is far too important to be taken seriously

• Tania Guyer

  SSC Enthusiast

  Points: 113

  More actions

  May 2, 2005 at 3:44 am

  #556234

  Thank you Journeyman, i already found article about it :

  http://www.sqlservercentral.com/columnists/pibison/alteringacolumnonareplicatedtable.asp

  Tania