I have two SQL Server 2005 Standard Edition servers in my development environment that are configured for both Merge and Transactional replication. Server A is the publisher for both, Server B is the subscriber for transactional and a merge participant. One of our developers is trying to update a stored procedure on the publisher and fails with this error:
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
The developer is a member of db_ddladmin, db_datareader/writer, db_securityadmin, db_accessadmin in the publication database, but is NOT a member of db_owner by design/policy. I have turned off the "Replicate schema changes" option in Subscription Options for both publications, as it appeared in BOL as though any ALTER PROCEDURE statement is replicated when that option is turned on. (We do not replicate any stored procedures in either publication.) Unfortunately, the developer continues to receive this error message.
Is this a Microsoft bug? Is my only recourse (other than executing all SP changes myself) to make developers DBO?
~~ Everything in moderation, including moderation. ~~