x

altered stored procedure in subscriber is not being replicated in publisher

Hi,

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!

more ▼

asked Oct 04, 2013 at 07:10 AM in Default

avatar image

DoctorCeline
30 1 3 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Oct 07, 2013 at 02:44 AM

avatar image

DoctorCeline
30 1 3 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x377

asked: Oct 04, 2013 at 07:10 AM

Seen: 673 times

Last Updated: Oct 07, 2013 at 10:13 AM

Copyright 2017 Redgate Software. Privacy Policy