Re: Table owner is not dbo.
From: Heinz Deubler (HeinzDeubler_at_discussions.microsoft.com)
Date: 01/14/05
- Next message: mspradley: "Merge snapshot problem with views and ArticleType property with SQ"
- Previous message: Paul Ibison: "Any alert system for Merge Replication Conflicts???"
- In reply to: Kestutis Adomavicius: "Re: Table owner is not dbo."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 14 Jan 2005 07:17:05 -0800
That is it, that you very much.
Heinz
"Kestutis Adomavicius" wrote:
> 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
>
>
>
- Next message: mspradley: "Merge snapshot problem with views and ArticleType property with SQ"
- Previous message: Paul Ibison: "Any alert system for Merge Replication Conflicts???"
- In reply to: Kestutis Adomavicius: "Re: Table owner is not dbo."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
