Hi
Using merge replication - the stored procs are published articles.
When trying to change the article at the subscriber (sql express) I get the following errors:
Msg 21531, Level 16, State 1, Procedure sp_MSmerge_alterschemaonly, Line 45
The DDL statement cannot be performed at the Subscriber or Republisher.
Msg 21530, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 181
The DDL operation failed inside merge DDL replication manipulation.
Msg 3609, Level 16, State 2, Procedure usp_Anniversary_upd, Line 21
The transaction ended in the trigger. The batch has been aborted.
Does this mean it can only be changed at the publisher ?
Bruce
correct. If you want to make schema changes at the subscriber, you need to set @.replicate_ddl to false in sp_addmergepublication.|||Schema changes cannot be made at the subscriber. They have to come from the Publisher.
I believe Greg meant "publisher only" instead of "subscriber" in the above statement.
|||Hi
Just to clarify this.....
1. You cannot change it at the subscriber, irrespective of whether @.replicate_ddl is set to 0 or 1 ?
2. If @.replicate_ddl is set to 1, then changing the proc on the publisher will result in the proc being changed at the subscriber next time it is synchronised (if a published article)
Is this correct ?
I ask, because @.replicate_ddl is set to 1, but I get that error mentioned earlier if I try and change it at the subscriber.....
Thanks
Bruce
1. you're correct, i was wrong in my earlier post.
2. correct.
No comments:
Post a Comment