all groups > sql server replication > april 2007 >
You're in the

sql server replication

group:

merge replication picking up tables not in the articles


merge replication picking up tables not in the articles jaylou
4/11/2007 7:18:04 AM
sql server replication:
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.

Re: merge replication picking up tables not in the articles Hilary Cotter
4/12/2007 12:35:35 PM
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



[quoted text, click to view]

Re: merge replication picking up tables not in the articles jaylou
4/13/2007 5:34:04 AM
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.

[quoted text, click to view]
AddThis Social Bookmark Button