SQLTeam.com | Weblogs | Forums

Merge Replication Issue


#1

Hi ,

I am using SQL 2017,i have one table which is part of Merge Replication. for that table i have trigger which is placed in subscription. but i am unable to alter the trigger getting the following error

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 sys.sp_MSmerge_ddldispatcher, Line 193 [Batch Start Line 7]
The 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 trg_Del_AUDIT_CollectionAccess, Line 2 [Batch Start Line 7]
The transaction ended in the trigger. The batch has been aborted.

Note: i have Admin Access

Please help me on this issue.


#2

Is the trigger present at publication?