dba2dba
asked on
unable to ALTER a view in a replicated database.
Hello Experts,
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.
-RK
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.
-RK
ASKER
indianguru2:
Thanks for your response.
I verified that there is no trigger created on the table. could there be any other possibility why this happens.
-RK
Thanks for your response.
I verified that there is no trigger created on the table. could there be any other possibility why this happens.
-RK
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The View is just from one table. Few columns are derived to a view.
Iam trying to add a new column to the view.
is, replication ID is sysadmin. Im a DDL admin and trying to ALTER it.
I see that the procedure is a system procedure, Please take a look at this link
http://www.g-productions.nl/mssql_procedure.php?name=sp_MSreplcheck_publish
Thanks,
Iam trying to add a new column to the view.
is, replication ID is sysadmin. Im a DDL admin and trying to ALTER it.
I see that the procedure is a system procedure, Please take a look at this link
http://www.g-productions.nl/mssql_procedure.php?name=sp_MSreplcheck_publish
Thanks,
sorry this database is a publisher?
if it is I believe that the id which is having the problem is not yours but the id under which thereplication is running...
have you published this view in an article?
if it is I believe that the id which is having the problem is not yours but the id under which thereplication is running...
have you published this view in an article?
Read this article : http://www.databasejournal.com/features/mssql/print.php/3581846