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).
Note
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
On the Articles page of the New Publication Wizard, expand the table to be filtered in the Objects to publish pane.
Clear the check box next to each column you want to filter.
To modify column filtering
On the Articles page of the Publication Properties - <Publication> dialog box, expand the table to be filtered in the Objects to publish pane.
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.
Click OK.
See Also
Concepts
Other Resources
How to: Define and Modify a Column Filter (Replication Transact-SQL Programming)