Friday, March 30, 2012

Replication to a Different Owner

Hello,
I'm replicating from one server to another. The issue is that the objects
on the second server have a different owner than the first server. Is this
possible? If so, how do I set it up?
Jligda,
have a look at the article properties - there is the option to set a
different object owner there. Obviously the user must pre-exist on the
subscriber, but this can be done by selecting to apply a script before the
snapshot is run which uses sp_grantdbaccess.
HTH,
Paul Ibison

No comments:

Post a Comment