Structure changes in tranasctional replication

• Dennis-214270

  SSC Veteran

  Points: 291

  More actions

  September 26, 2012 at 10:55 am

  #282194

  I have Transactional replication setup between 2 SQL Server 2005 Servers.

  I have made structure changes (add 2 columns) to a Published table.

  From what I have read, as long as I have Replicate Schema changes set to True for the subcription, it should replicate the structure changes to the DB on the Subscriber side.

  I executed sp_browsereplcmds against the Distributer but I have not seen the changes go over.

  Can anyone help?????

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  September 26, 2012 at 11:53 pm

  #1542707

  Do you have access to the subscriber? If yes you can easily check and confirm.