August 27, 2007 at 3:34 pm
I had setup a transactional replication in our environment with all the default article properties. All the objects on the subscriber are now created with owner 'dbo'.
But on publisher there are some objects which uses different owner. Is there a way that I can change the articles properties on the subscriber so that I can have same object owner as publisher?
Thanks in advance.
August 29, 2007 at 9:57 pm
I do not think you can because each object has its full name including its ownership.
August 29, 2007 at 10:20 pm
This is actually quite easy to setup.
If you are using Enterprise Manager to create the articles, you should go to the article properties. You can get there in the "Specify Articles" step of the create publication wizard by clicking on the elipses (...) next to the table name. In the article properties, you can type the owner of the object.
If you are using the replication stored procedures, sp_addarticle has a parameter called @destination_owner
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply