Re: Table owner is not dbo.

From: Kestutis Adomavicius (kicker.lt_at_nospaamm_tut.by)
Date: 01/14/05 

Date: Fri, 14 Jan 2005 09:34:45 +0200

For every publication article you can set destination object owner. By
default it is not specified, which means that it will be dbo. As owner of
objects on publisher is not dbo, you should specify the same owner for
destination objects. That can be done in article properties when setting up
replication. 

-- 
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"Heinz Deubler" <HeinzDeubler@discussions.microsoft.com> wrote in message
news:CFD6893A-B2ED-4277-816C-3EE8F425CB6B@microsoft.com...
> I am trying to replicate a database where the table owner is not [dbo] but
> [docsadm]. When I replicat the database to the subscriber all the tables
are
> duplicated where one set of tables has [dbo] as owner and the another set
of
> tables has [docsadm] as owner.
> I tried to set the flag 'keep the existing table unchanged' but then I get
> the following error 'Connot created an index on 'APPS', because this tabel
> does not exist.
>
> Thanks
> Heinz

Relevant Pages

  • Re: Developer design Best Practices
    ... The database owner login is a special case and is not specified like a ... You can execute sp_changedbowner to specify the owner or ... > and then I move them, and the owner is dbo. ... > There is NO DBO User in our dev database!! ...
    (microsoft.public.sqlserver.server)
  • 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: Table owner is not dbo.
    ... "Kestutis Adomavicius" wrote: ... > default it is not specified, which means that it will be dbo. ... > objects on publisher is not dbo, you should specify the same owner for ...
    (microsoft.public.sqlserver.replication)
  • 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)
  • Re: Question about dropping owners permissions...
    ... When a member of the db_owner role creates an object, ... dbo, must the owner must be specified: ... >>> create databases themselves. ... Can anyone help me reach my end goal: Allowing developers to ...
    (microsoft.public.sqlserver.security)