Re: Snapshot agent - Filter Rows

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Hilary,

How can I get the publication schema?

Thanks!

Ben

"Hilary Cotter" wrote:

Could you post the publication schema and the schema of the table
CustomerPurchaseOrder and all related tables?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



"Ben" <Ben@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:67C154DC-4217-4CF7-980A-9466161FC9FF@xxxxxxxxxxxxxxxx
Hi,

I am trying to setup merge replication. I have selected some tables to be
filtered. The snapshot agent was returning the following error:

Message: In order to use partition_options of 2 (non overlapping
partitions
with multiple subscriptions per partition) or 3 (non overlapping
partitions
one subscription per partition) the publication 'SE_DellStation' must be
enabled to use partition groups functionality. Use
sp_changemergepublication
to set 'use_partition_groups' to 'true'.
Command Text: sp_MSvalidate_wellpartitioned_articles
Parameters: @publication = SE_DellStation

I changed the value of 'use_partition_groups' to 'true' with the sp and
when then the snapshot agent returned the following error:


Error messages:
Message: Precomputed partitions cannot be used because articles
"[dbo].[CustomerPurchaseOrderDetail]" and "[dbo].[CustomerPurchaseOrder]"
are
part of a join filter and at least one of them has a constraint with a
CASCADE action defined.
Command Text: sys.sp_MSset_dynamic_filter_options
Parameters: @publication = SE_DellStation
@dynamic_filters =

The table CustomerPurchaseOrder is filter by another table
(Store.st_row_id). And Store.st_row_id is filtered by a specific row id.

I am not sure what to look for. Help will be greatly appreciated.

Thanks

Ben



.

Relevant Pages

  • Re: Delete a subscription
    ... subscriptions tab, and delete it there. ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... You should also be able to expand the publication on the publishers ...
    (microsoft.public.sqlserver.replication)
  • Re: Precomputed Partitions
    ... The publication in question has many subscribers that are currently at MSDE ... through the use of the precomputed partitions feature. ...
    (microsoft.public.sqlserver.replication)
  • Re: drop col from published table
    ... What is the exact error ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Do I need to drop the publication before adding col? ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot agent - Filter Rows
    ... Could you post the publication schema and the schema of the table ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ...
    (microsoft.public.sqlserver.replication)
  • Re: adds articles to a publication
    ... Can you either put it in a separate publication or re-initialize the entire ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... exec sp_reinitsubscription @publication = N'Publisher', ...
    (microsoft.public.sqlserver.replication)