Re: changing table owner name- sp_changemergearticle

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

It works for me, here is what I use:

sp_changemergearticle 'pubs2','authors','destination_owner','newownername'
,@force_invalidate_snapshot=1,@force_reinit_subscription=1


--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



<amritha.prabhu@xxxxxxxxx> wrote in message
news:1149248072.423451.171750@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: changing table owner name- sp_changemergearticle
    ... Hilary Cotter wrote: ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... I have a db with a few tables which has owner than dbo. ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication and User Mapping
    ... You are correct Paul. ... objects I work with are owned by dbo, and I need to set permissions. ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ...
    (microsoft.public.sqlserver.replication)
  • Re: Invalid Descriptor Index
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication from SQL Server 2005 to SQL Express using RMO
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Const DB_AUTHENTICATION = 0 ... RMO is just like DMO, but only contains the replication components. ...
    (microsoft.public.sqlserver.replication)
  • Re: Backup failure due to full-text indexing
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Shift the backup log after backup database (it was starting at the same ... "Hilary Cotter" wrote: ...
    (microsoft.public.sqlserver.fulltext)