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
LVL 8
dba2dbaAsked:
Who is Participating?
 
LowfatspreadConnect With a Mentor Commented:
what does the view look like?
what alteration are you trying to make?

is the replication id a member of sysadmin or ddladmin or dbo...

confirm that the procedure mentioned is a generated replication procedure?
0
 
indianguru2Commented:
You have some trigger attached to your tables.
Read this article : http://www.databasejournal.com/features/mssql/print.php/3581846 
0
 
dba2dbaAuthor Commented:
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
0
 
dba2dbaAuthor Commented:
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,


0
 
LowfatspreadCommented:
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?
0
All Courses

From novice to tech pro — start learning today.