Change Object Owner of Published Table

Last Post 12 Apr 2004 02:48 PM by bigelectricmac. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bigelectricmac
New Member
New Member

--
12 Apr 2004 08:40 AM
Is there a quick way to change the owner of a replicated article from a userName.tableName to dbo.tableName without dropping the table from the publication, adding it back to the publication and then pushing a new snapshot. I would like to get around the snapshot. This is straight transactional replication.
bigelectricmac
New Member
New Member

--
12 Apr 2004 02:48 PM
This may be sort of a hack, but could I:

1. Change object ownership of article on publisher and then let replication break.
2. Change object ownership on subscriber and manually update all replication procs for the articles (I have 13 articles to do).
3. Restart replication.

Do you think this is worth trying.
You are not authorized to post a reply.

Acceptable Use Policy