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.
- 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.
- On the Filter Data page, select Vertically, by filtering the columns of published data.
- 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.