I am unable to ALTER a view in a replicated database.
Replication has been newly setup for this database.
I have DDL Admin permissions on the database and Alter View is failing with the below error:
Msg 21050, level 14, State 1, Procedure sp_MSreplcheck_publish, line 16
Only members of the sysadmin fixedserver role or db_owner fixed database role can perform this operation. Contact an administrator with sufficient permissions to perform this.
msg 3609, level 16, State 2, procedure <ViewName>
The transaction ended in the trigger. The batch has been aborted.
It is SQL Server 2005 Std on Win 2K3.
Is replication causing this. Please help me in solving this.