merge replication where deletes are required

Hello all,
I am desperatly need help, our setup is a SQL 2005 server, with merge
replication.
Filtered rows and 120 pocket pcs (subscribers).
We need to delete 100000 rows each night, plus minor inserts, and every time
each pocketpc gets all deletes which kills me and them. I have searched the
net how to achive this without any luck.
I have tried to "reinitilize all" with upload changes, + create new snapshot
+ delete the subscriber and nothing help, all deletes get sent to the
subscriber.
I cannot believe that there are no solution for this common problem, and why
does all the deletes get out to all the subscribers when we have filtered
rows and it works fine with inserts or update?
Please help, anything is better than what we have, and the nightly deletes
are required.
Perhaps you could temporarily turn off the delete tracking:
http://msdn2.microsoft.com/en-us/library/ms146947.aspx?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Merge Replication Error - Help Required...

Dear Friends,
I am very new to replication, For learning purpose I am trying to setup merge replication. The given setup I am using.

1. Windows 2000 Server + SP4 (Publisher for SQL 2000)
2. Windows 2003 Server + SP1 (Subscriber For SQL 2000)

I am getting a replication error, I have taken this errors details from merge agent on publisher server.

Find enclosed replication error details in the microsoft document file format (.doc). The document is consist of three SQL Server snapshot rather three diffrent errors.

In the pictures you can find the red & white color cross (wrong sign) on replication monitor tab, I don't know why it is appearing. :confused:

Kindly, give me guidance to rectify this error & setup the marge replication between two SQL 2000 Servers.It appears to be a folder or file permissions issue:

Full (Error) Message : The process could not read file '\\RENMAIL\C$\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\RENMAIL_pubs_pubs\200604 18105537\publishers_1.sch' due to OS error 5.

OS error 5 is "Access is Denied" (net helpmsg 5).

You need to check the permissions on the folder to which the snapshot is published and verify that the SQL Server Service account for the publisher has read/write access to this folder.

Regards,

hmscott|||Yeah, you're right hmscott that appropriate rights assignment is essential.

But there is other properties also to configured... At the last I have configured "Microsoft SQL Server Replication Remote Dist Agent 8.0" DCOM property on the operating system. The command line to configure DCOM is 'dcomcnfg'.

Now merge replication is working good... Thanx...

Merge Replication Error - A dynamic snapshot is required

Any info on this error:
Scenario:
Replication Server: Sql Server 2005
Replication client: SQL Server Express Edition
I have setup a merge publication on SQL Server 2005, with a dynamic
filter (using HOST_NAME()) defined on one of the articles, also I have
defined a logical record.
(To be precise it is a logical record without join filter, I have done
this using 'sp_addmergefilter' and specifying the @.filter_type = 2
value which configures it just as logical record without a join filter)
Subscription (am using push) to this Publication is successful, but
when I see Replication Monitor, I get the following error there:
A dynamic snapshot is required because the publication 'XYZ' contains
both dynamic filters and logical record relationships.
How do i configure dynamic snapshot? Any info this error would be great.
I tried the following stored procedure to add a dynamic snapshot:
exec sp_adddynamicsnapshot_job
@.publication = 'XYZ',
@.suser_sname = NULL,
@.host_name = sysname,
@.frequency_type= 2
but am still getting the same error "A dynamic snapshot is required
because the publication 'XYZ' contains
both dynamic filters and logical record relationships. "
On Jan 25, 4:25 pm, narasimha...@.gmail.com wrote:
> Any info on this error:
> Scenario:ReplicationServer: Sql Server 2005Replicationclient: SQL Server Express Edition
> I have setup amergepublication on SQL Server 2005, with a dynamic
> filter (using HOST_NAME()) defined on one of the articles, also I have
> defined a logical record.
> (To be precise it is a logical record without join filter, I have done
> this using 'sp_addmergefilter' and specifying the @.filter_type = 2
> value which configures it just as logical record without a join filter)
> Subscription (am using push) to this Publication is successful, but
> when I seeReplicationMonitor, I get the following error there:
> Adynamic snapshotis required because the publication 'XYZ' contains
> both dynamic filters and logical record relationships.
> How do i configuredynamic snapshot? Any info this error would be great.