Hello,

I am having the same problem. I had given developers DDL_Admin rights and it was working fine. I just need to setup merge replication for few tables and transactional for other tables. however developer started complaining that they are getting following error while altering procedure (although procedures are getting altered)

Msg 21050, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 12

Only members of the sysadmin fixed server role or db_owner fixed database role can perform this operation. Contact an administrator with sufficient permissions to perform this operation.

I am not replicating any procedures. I am only replicating few tables.

Not sure why above procedure gets executed and why it needs to check owner.

can someone let me know how to resolve this issue? I do not wish to grant developers more rights.

Jatin Soni