|
This tab only applies to SQL Remote publications and is only shown if the publication has a synchronization type of log scan.
The SUBSCRIBE BY Restrictions tab lets you define a subset of rows of a table for inclusion in the article.
The SUBSCRIBE BY Restrictions tab of the Publication property sheet has the following components:
Articles list Select an article from the list of articles included in the publication.
This article has the following SUBSCRIBE BY restriction You can choose one of the following options for the SUBSCRIBE BY restriction for the article:
None Select this option if the article does not have a SUBSCRIBE BY restriction.
Column Sets the article to partition rows from the table based on a column (SUBSCRIBE BY columns). Once you select this option, you must select a column from the dropdown list.
Expression Sets the article to partition rows from the table based on an expression entered in the field below.