I've been troubled for a today to find solution/or supporting articles on my current issue in my Transactional Replication with updatable subscriber. here's the scnario;
Microsoft says, we can alter, update stored procedure in either publisher or subscriber. as default, we do our alter and updates in publisher and it replicated to our subscribers as design but how about if the alter and update is made in subscriber?
i had this issue, one of our programmer did alter his stored procedure by adding 'order by' t-sql command in the subscriber and it never replicated to the publisher. I have run the snapshot and still not being replicated.
please help. thanks!
asked Oct 04, 2013 at 07:10 AM in Default
the answer of this question is in this link... http://technet.microsoft.com/en-us/library/ms151870(v=sql.105).aspx
any schema changes should be done in publisher.