Export (0) Print
Expand All
Expand Minimize

How to: Define and Modify a Column Filter (SQL Server Management Studio)

Define column filters on the Articles page of the New Publication Wizard. For more information about using the New Publication Wizard, see How to: Create a Publication and Define Articles (SQL Server Management Studio).

Define and modify column filters on the Articles page of the Publication Properties - <Publication> dialog box. For more information about publication and article properties, see How to: View and Modify Publication and Article Properties (SQL Server Management Studio).

NoteNote

Some columns cannot be filtered; for more information, see Filtering Published Data. If you modify a column filter after subscriptions have been initialized, you must generate a new snapshot and reinitialize all subscriptions after making the change. For more information about requirements for property changes, see Changing Publication and Article Properties.

To define a column filter

  1. On the Articles page of the New Publication Wizard, expand the table to be filtered in the Objects to publish pane.

  2. Clear the check box next to each column you want to filter.

To modify column filtering

  1. On the Articles page of the Publication Properties - <Publication> dialog box, expand the table to be filtered in the Objects to publish pane.

  2. Clear the check box next to each column you want to filter, and ensure that the check box is selected for each column that should be included in the article.

  3. Click OK. 

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft