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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
LowfatspreadCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.