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.

bigelectricmacNew Member

12 Apr 2004 03: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.