Hi all,
Our set up is 2016 SQL server and we are using P2P transactional replication among our four servers.
Recently one of the servers is reporting that it is trying to apply command "if COLUMNPROPERTY(OBJECT_ID('MSreplication_subscriptions'), 'distribution_agent', 'AllowsNull') <> 1 BEGIN alter table MSreplication_subscriptions alter column distribution_agent sysname null END" to one of its subscribers and it has failed because "only members of the (null) role can execute this stored procedure". Can anyone please explain what is distributor trying to do? what does this command do to the subscriber? Please let me know if more information is needed.
Thank you