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.