How to filter publications horizontally using publication properties (Enterprise Manager)

How to Install SQL Server 2000

How To

How to filter publications horizontally using publication properties (Enterprise Manager)

  1. In SQL Server Enterprise Manager, expand the Replication and Publications folders, right-click the publication for which you want to add a row filter, and then click Properties.

  2. On the Filter Rows tab, click the Filter Clause (...) button next to the article you want to filter, and then in the Specify Filter dialog box, complete the WHERE clause with a condition for the filter.