How to filter publications vertically using the Create Publication Wizard (Enterprise Manager)

How to filter publications vertically using the Create Publication Wizard (Enterprise Manager)

Note  If you are creating a merge publication for use with Subscribers running Microsoft® SQL Server™ version 7.0, you will not be able to create a vertical filter and you will not see the Filter Columns page in the Create Publication Wizard.

1. In the Create Publication Wizard, on the Customize the Properties of the Publication page, select Yes, I will define data filters, enable anonymous subscriptions, or customize other properties.
   
   
2. On the Filter Data page, select Vertically, by filtering the columns of published data.
   
   
3. On the Filter Table Columns page, click the table in the publication for which you want to add a vertical filter, and then clear the columns you do not want included in the publication.