Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Structure changes in tranasctional replication Expand / Collapse
Author
Message
Posted Wednesday, September 26, 2012 10:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 1, 2012 1:15 PM
Points: 7, Visits: 20


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?????
Post #1364842
Posted Wednesday, September 26, 2012 11:53 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 4:17 AM
Points: 1,101, Visits: 5,279
Do you have access to the subscriber? If yes you can easily check and confirm.
Post #1365038
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse