I'm trying to change a view on a testing database. I got message:
Msg 21531, Level 16, State 1, Procedure sp_MSmerge_alterschemaonly, Line 45
The 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 182
The schema change failed during execution of an internal replication procedure. For corrective action, see the other error messages that accompany this error message.
I think it is because DDL trigger was there to provent db objects changes.
I want to change a view to test my report. What would be a good way to make myself being able to make changes to my store procedures? Thanks.