Replication error on tables with different owners

Hi Freinds,
SQL2000
I want to replicate a database that has tables with different schemas.
user1.invoice
user2.invoice
user2.invoice
user1.invoice_detail
user2.invoice_detail
..
..
..
When t run the snapshot, itcreates the tables for dbo and causing problems.
What are my options to roll over this error and problem?
Thanks in advance,
Pat
I assume you mean
user1.invoice
user2.invoice
user3.invoice
If this is the case, put the accounts in place in your subscriber using a
pre snapshot command. Then use sp_addarticle to create the different tables.
The @.destination_owner parameter allows you to specify different owner
names.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Patrick" <patriarck@.gmail.com> wrote in message
news:OUA5aUYuFHA.904@.tk2msftngp13.phx.gbl...
> Hi Freinds,
> SQL2000
> I want to replicate a database that has tables with different schemas.
> user1.invoice
> user2.invoice
> user2.invoice
> user1.invoice_detail
> user2.invoice_detail
> .
> .
> .
> When t run the snapshot, itcreates the tables for dbo and causing
problems.
> What are my options to roll over this error and problem?
> Thanks in advance,
> Pat
>
|||So , basicly it is a manual proces for creating the article and pushing the
replication !
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:e6YeGyZuFHA.1196@.TK2MSFTNGP10.phx.gbl...
>I assume you mean
> user1.invoice
> user2.invoice
> user3.invoice
> If this is the case, put the accounts in place in your subscriber using a
> pre snapshot command. Then use sp_addarticle to create the different
> tables.
> The @.destination_owner parameter allows you to specify different owner
> names.
>
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Patrick" <patriarck@.gmail.com> wrote in message
> news:OUA5aUYuFHA.904@.tk2msftngp13.phx.gbl...
> problems.
>
|||Well, not really. Most of the functionality is wizard driven, however to do
things outside of the scope of the wizards you have to do some manual steps.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Patrick" <patriarck@.gmail.com> wrote in message
news:OG5qvuhuFHA.904@.tk2msftngp13.phx.gbl...
> So , basicly it is a manual proces for creating the article and pushing
> the replication !
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:e6YeGyZuFHA.1196@.TK2MSFTNGP10.phx.gbl...
>