"Roger Nygård" <roger@askit.no> wrote in message
news:11uemak27qnmp5d@corp.supernews.com...
> Win2003srv
> mssql2000
> mssql2005
> Oracle
>
> I have a mssql2000 database that I Replicate to oracle,
> some tables have row filtering.
> This was working fine until I create an another publication and
> subscription (transaction)
> on the same database, for mssql2005 This subscription has the
> loopback_detection = N'True',
>
> After this, the Oracle subscription stop to work correctly
> Tables with row filter are not replicated. In Repl Monitor everything
> looks fine
>
> I try to delete all publication and then re-crate it and start snap-shot
> for oracle
> The bulk copying are doing the right thing regarding filter-rows.
> But the distributor agent will not work properly
> I can see the log-reader pushing transaction to the distibutor , but
> nothing happens
>
> What is wrong her?
>
>
> -roger
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23w5ntqyKGHA.2036@TK2MSFTNGP14.phx.gbl...
> What do you see if you run a sp_browsereplcmds in the distribution
> database? The oracle DML should be showing up here.
>
> --
> 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
>
> "Roger Nygård" <roger@askit.no> wrote in message
> news:11uemak27qnmp5d@corp.supernews.com...
>> Win2003srv
>> mssql2000
>> mssql2005
>> Oracle
>>
>> I have a mssql2000 database that I Replicate to oracle,
>> some tables have row filtering.
>> This was working fine until I create an another publication and
>> subscription (transaction)
>> on the same database, for mssql2005 This subscription has the
>> loopback_detection = N'True',
>>
>> After this, the Oracle subscription stop to work correctly
>> Tables with row filter are not replicated. In Repl Monitor everything
>> looks fine
>>
>> I try to delete all publication and then re-crate it and start snap-shot
>> for oracle
>> The bulk copying are doing the right thing regarding filter-rows.
>> But the distributor agent will not work properly
>> I can see the log-reader pushing transaction to the distibutor , but
>> nothing happens
>>
>> What is wrong her?
>>
>>
>> -roger
>>
>>
>
>