Structure changes in tranasctional replication

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Structure changes in tranasctional...

Structure changes in tranasctional replication

Rate Topic

Display Mode

Topic Options

Author

Message

Dennis-214270

Posted Wednesday, September 26, 2012 10:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 01, 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

Suresh B.

Posted Wednesday, September 26, 2012 11:53 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 4:49 AM
Points: 1,075, Visits: 5,119

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

Post #1365038

« Prev Topic | Next Topic »

Permissions