Snapshot replication table belongs to differnet owner
From: Jenny (anonymous_at_discussions.microsoft.com)
Date: 02/18/04
- Next message: Fulya Erol: "drop foreign keys for replication to work"
- Previous message: Michael: "Snapshot agent: The process could not connect to Distributor 'SERVER1'"
- In reply to: Paul Ibison: "Snapshot replication table belongs to differnet owner"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 18 Feb 2004 12:43:45 -0800
Thanks Paul,
Jenny
>-----Original Message-----
>Jenny,
>if you want an alternative owner to dbo for the article
>then enter the table article properties and on the
general
>tab you can specify the owner. If this is not entered the
>object will be created by the sql agent, which as it is
>usually in the sysadmin role, will map to dbo in the
>subscriber database. Once you've changed the owner, the
>distribution agent will error if the user doesn't already
>exist in the subscriber database. If this is the case
then
>a pre-script can be used to add it.
>Regards,
>Paul Ibison
>.
>
- Next message: Fulya Erol: "drop foreign keys for replication to work"
- Previous message: Michael: "Snapshot agent: The process could not connect to Distributor 'SERVER1'"
- In reply to: Paul Ibison: "Snapshot replication table belongs to differnet owner"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
