Snapshot replication table belongs to differnet owner

From: Paul Ibison (anonymous_at_discussions.microsoft.com)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 09:33:16 -0800

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

Relevant Pages

  • Snapshot replication table belongs to differnet owner
    ... >if you want an alternative owner to dbo for the article ... >then enter the table article properties and on the ... >tab you can specify the owner. ... >exist in the subscriber database. ...
    (microsoft.public.sqlserver.replication)
  • changing table owner name- sp_changemergearticle
    ... I have a db with a few tables which has owner than dbo. ... subscriber. ... In order to avoid this i went to the article properties on the ...
    (microsoft.public.sqlserver.replication)
  • Re: changing table owner name- sp_changemergearticle
    ... But when I insert the result set of all the user table names and owner ... I have a db with a few tables which has owner than dbo. ... In order to avoid this i went to the article properties on the ... incorrect syntax when i execute it.? ...
    (microsoft.public.sqlserver.replication)
  • Re: ADP: Cant use stored procedure on remote SQL server
    ... Not only I use dbo everywhere but I ... If you don't mention the owner when creating a new stored procedure, view, ... BTW in the database window, all the stored procedures are followed by ... Check also the owner of the SPInc stored procedure. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: rda push when owner is not dbo.
    ... If I launch the sql query analyzewr and try to run the ... I'm pretty configdent that the owner name not being qualified is the ... > I pull the table with rda to a local table named task. ... > I also created a test table in the same database with owner dbo and I ...
    (microsoft.public.sqlserver.ce)
Loading