Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


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.

© 2015 Microsoft