"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
>
>

"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...
>> 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
>>
>>
>
>

"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...
>>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
>>>
>>>
>>
>>
>
>