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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment