Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sysmergesubsetfilters

SQL Server 2000

Contains join filter information for partitioned articles. This table is stored in the publication and subscription databases.

Column name Data type Description
filtername sysname Name of the filter used to create the article.
join_filterid int ID of the object representing the join filter.
pubid uniqueidentifier ID of the publication.
artid uniqueidentifier ID of the article.
art_nickname int Nickname of the article.
join_articlename sysname Name of the table to join to determine whether the row belongs.
join_nickname int Nickname of the table to join to determine whether the row belongs.
join_unique_key int Indicates a join on a unique key of join_tablename:

0 = Not a unique key.
1 = A unique key.

expand_proc sysname Name of the stored procedure used by the Merge Agent to identify the rows that need to be sent or removed from a Subscriber.
join_filterclause nvarchar(1000) Filter clause used for the join.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.