sql server replication: Merge Replication Error - A dynamic snapshot is required -- sql server replication

Merge Replication Error - A dynamic snapshot is required

narasimha.gm NO[at]SPAM gmail.com
1/25/2007 3:25:41 AM

sql server replication:

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.

Re: Merge Replication Error - A dynamic snapshot is required

narasimha.gm NO[at]SPAM gmail.com
1/25/2007 7:23:02 AM

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. "

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.