Wednesday, March 21, 2012

merge replication picking up tables not in the articles

I am having a strange issue with my merge repl. I have set my verbose level
to 2 which is the highest, and I see an error on a table that is not in my
articles being published but the repl is failing for it. the table exists in
my centralized database but not in my branch's. I can't find any references
to it in my replication.
can anyone tell me where I can look to see why repl is trying to delete from
this table?
TIA.
Can you script out your publication to see if it occurs there?
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
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:1AC0EA95-F1EE-4630-9B99-1E66A7BAF026@.microsoft.com...
>I am having a strange issue with my merge repl. I have set my verbose
>level
> to 2 which is the highest, and I see an error on a table that is not in my
> articles being published but the repl is failing for it. the table exists
> in
> my centralized database but not in my branch's. I can't find any
> references
> to it in my replication.
> can anyone tell me where I can look to see why repl is trying to delete
> from
> this table?
> TIA.
>
|||I did try that and there were no references there either. Thats when I
decided to ask the experts
Anyway, I added the tables being referenced and all is well. You also
answer my other question about an incorrect Parameter, I did as you suggested
but it was still wrong, I removed it since the repl was working fine and my
repl was successful last night.
Thanks again for your help.
"Hilary Cotter" wrote:

> Can you script out your publication to see if it occurs there?
> --
> 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
>
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:1AC0EA95-F1EE-4630-9B99-1E66A7BAF026@.microsoft.com...
>
>

No comments:

Post a Comment