changing table owner name- sp_changemergearticle

Hi,
I have a db with a few tables which has owner than dbo. When i use this
db for merge replication it creates tables with owner as dbo on the
subscriber.
In order to avoid this i went to the article properties on the
publisher and changed the destination owner to the 'other user' not
'dbo' and created the subscription again it worked fine.
Now my question is how can i change the article settings through the
stored proc "sp_changemergearticle". I tried using this but its saying
incorrect syntax when i execute it.? I am new to this field.. Can any
one help me out on this..
If an example could be given it could be of great help.

Thanks,
A

.

Relevant Pages

  • Re: looking for more info on merge repl problem
    ... just change the owner on each table individually to user 'dbo' or should I ... >> Publisher or Subscriber, or non dbo owner names on both your Publihser ... >> Looking for a book on SQL Server replication? ...
    (microsoft.public.sqlserver.replication)
  • Re: ADP: Cant use stored procedure on remote SQL server
    ... Not only I use dbo everywhere but I ... If you don't mention the owner when creating a new stored procedure, view, ... BTW in the database window, all the stored procedures are followed by ... Check also the owner of the SPInc stored procedure. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: rda push when owner is not dbo.
    ... If I launch the sql query analyzewr and try to run the ... I'm pretty configdent that the owner name not being qualified is the ... > I pull the table with rda to a local table named task. ... > I also created a test table in the same database with owner dbo and I ...
    (microsoft.public.sqlserver.ce)
  • Re: Question about dropping owners permissions...
    ... When a member of the db_owner role creates an object, ... dbo, must the owner must be specified: ... >>> create databases themselves. ... Can anyone help me reach my end goal: Allowing developers to ...
    (microsoft.public.sqlserver.security)
  • Re: User names
    ... I don't have a pre-sp3 server to try this on, but in sp3, if you are a user ... byjust specifically giving the owner name in QA. ... > dbo was the owner. ...
    (microsoft.public.sqlserver.server)
Loading