Hey guys, wondering if i can get some wisdom on why this merge replication wont work... i can get the snapshot working, i can push the subscription to the subscriber, but i cant modify a stored procedure on the subscriber and get it to push to the publisher... any ideas on what i can be doing wrong?when i do it with merge, i get the following error:Msg 21531, Level 16, State 1, Procedure sp_MSmerge_alterschemaonly, Line 50The data definition language (DDL) command cannot be executed at the Subscriber. DDL commands can only be executed at the Publisher. In a republishing hierarchy, DDL commands can only be executed at the root Publisher, not at any of the republishing Subscribers.Msg 21530, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 191The schema change failed during execution of an internal replication procedure. For corrective action, see the other error messages that accompany this error message.Msg 3609, Level 16, State 2, Procedure aspnet_AnyDataInTables, Line 80The transaction ended in the trigger. The batch has been aborted.
When i try with Transactional with updateable sub. it just never updates the subscriber... any advice?Thanks!
Merge Replication wont recieve alter from client
Posted - 2009-07-06 : 01:43:26