Conflict table cleanup

Hello All -
Is there a process that automatically cleans the conflict tables?
I have a merge publication with publisher & distributer running on same
machine. This is SQL 2K and W2K host. The clients are push subscription.
I viewed several conflicts last week ( Friday) and postponed resolving them.
There were about 300 conflicts and I didn't view them all.
Today when I went to view them, EM told me that 'no conflicts table'.
Is there some automatic clean of the conflict tables?
Do conflicts get purged when re-initializing all client?
Thanks,
bruce
Yes we do cleanup the rows when the subscription is re-initialized, also
the conflict rows are deleted when we manually resolve it from the conflict
resolver.
thanks
gopal
|||Bruce,
This is not a cleanup, but a wipe out! Your problem could be related to the
fact that the Snapshot Agent may be running automatically.
Everytime this agent runs the conflict tables are dropped and recreated
(they say this is by design), therefore you will lose any conflicts that
were there before.
Raj Moloye

Conflict Resolution options disabled

I am using SQL Server 2000 and Enterprise Manager. I have a publication and
I am trying to follow some instructions for configuring conflict resolution.
I open the Publication properties, go to the Articles tab, open an Article by
clicking the ellipses, and then go to the Resolver tab. All of the controls
on the Resolver tab are disabled. Is there something else I must do first to
enable conflict resolution on at the Database or Publication level?
Some settings are database specific. Most likely what has happened is the
article you are trying to change the resolver type to is published in a
different publication. To make this work you will have to drop it from
existing publication, change the resolver type and then put it back in.
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
"Michael" <Michael@.discussions.microsoft.com> wrote in message
news:454325A9-2D83-4664-9ECB-9143C5257BDF@.microsoft.com...
>I am using SQL Server 2000 and Enterprise Manager. I have a publication
>and
> I am trying to follow some instructions for configuring conflict
> resolution.
> I open the Publication properties, go to the Articles tab, open an Article
> by
> clicking the ellipses, and then go to the Resolver tab. All of the
> controls
> on the Resolver tab are disabled. Is there something else I must do first
> to
> enable conflict resolution on at the Database or Publication level?

Configuring subscription database as publication.

Hi, I need to configure this scenario
Part 1: Transactional publication configured in database A, the
subscriber is database B.
Part II: Configure a transactional publication in database B and send it
to database C and D.
I already configure the part 1 of the scenario. But when i try to
configure part B, i have the problem that the tables in database b Dont
have primary key, I try changing this option on each article:
"Delete all data in the the existing table". Assuming that if i already
create the tables with primary key, it will work, but it didnt.
Do somebody know how to configure it?
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Maria,
on the article properties, select to take the declarative referential
integrity. This'll ensure that PKs don't become just unique indexes on the
subscriber, and the PKs will be created there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Configure Web syncronization using RMO or T-Sql

Hi
I have created merge publication using RMO programming on Sql Server
2005 and it will subscribe by Sql Server Mobile Edition.
Publication created successfully and wok fine but I have to Configure
Web synchronization manually instead of RMO programming. (In short
Configuring IIS for web synchronization).
So please any body have idea how to configure IIS for subscription
using RMO programming or any other way except manually follows the
step of configure web synchronization wizard.
Regards
Prakash
You can't. It involves creating a virtual directory, setting the correct
configuration for this (application pool, directory security, etc), putting
the isapi filter in place.
You can use ADSI for some of this, but not RMO or tsql.
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
"prakash" <patelprakashp@.gmail.com> wrote in message
news:1185804118.102611.31680@.i38g2000prf.googlegro ups.com...
> Hi
> I have created merge publication using RMO programming on Sql Server
> 2005 and it will subscribe by Sql Server Mobile Edition.
> Publication created successfully and wok fine but I have to Configure
> Web synchronization manually instead of RMO programming. (In short
> Configuring IIS for web synchronization).
> So please any body have idea how to configure IIS for subscription
> using RMO programming or any other way except manually follows the
> step of configure web synchronization wizard.
> Regards
> Prakash
>
|||On Aug 1, 5:43 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> You can't. It involves creating a virtual directory, setting the correct
> configuration for this (application pool, directory security, etc), putting
> the isapi filter in place.
> You can use ADSI for some of this, but not RMO or tsql.
> --
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com"prakash" <patelpraka...@.gmail.com> wrote in message
> news:1185804118.102611.31680@.i38g2000prf.googlegro ups.com...
>
>
Thanks a lots