how to alter column for replicated table

• pols

  SSC Eights!

  Points: 935

  More actions

  January 28, 2010 at 3:39 am

  #218601

  Hi,

  I have configured peer to peer replication

  Table name:Dctr

  ColumnName:Postingdctr

  For one artcle (Dctr) i need to change the datatype length like below..

  postingdctr nvarchar(20) to postingdctr nvarchar(60)

  Pls help me how change nvarchar(60)?

  Thanks,

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  January 28, 2010 at 6:00 am

  #1109895

  check the following link

  http://www.sqlservercentral.com/articles/Replication/alteringacolumnonareplicatedtable/1666/