Transactional replication and add coulmn

• sql1971

  SSC Enthusiast

  Points: 172

  More actions

  November 29, 2003 at 7:25 pm

  #101777

  Hello Friends, I am really new to replication. I have a table part of replication. What command I should use to add another column in this table and also make it part of replication.

  Please suggest.

• Eddie Wuerch

  SSChampion

  Points: 12535

  More actions

  November 29, 2003 at 10:28 pm

  #484047

  Take a look at sp_repladdcolumn in Books Online.

  * Warning: Books Online gives the wrong parameters for this sp - it misses one in the middle.

  You can view the parameter list, with types, using the following query:

  SELECT sc.Name AS [Parameter], st.Name AS [Type]

  FROM master.dbo.syscolumns sc (NOLOCK)

  INNER JOIN master.dbo.systypes st (NOLOCK) ON sc.xtype=st.xtype

  WHERE sc.id = OBJECT_ID('master.dbo.sp_repladdcolumn')

  ORDER BY sc.colid

  Eddie Wuerch
  MCM: SQL

• sql1971

  SSC Enthusiast

  Points: 172

  More actions

  November 30, 2003 at 6:18 am

  #484049

  Thanks, it works.