How to filter with a user-defined function using the Create Publication Wizard (Enterprise Manager)

How to Install SQL Server 2000

How To

How to filter with a user-defined function using the Create Publication Wizard (Enterprise Manager)

  1. In the Create Publication Wizard, on the Customize the Properties of the Publication page, select Yes, I will define data filters, enable anonymous Subscribers, or customize other properties.

  2. On the Filter Data page, select Horizontally, by filtering the rows of published data.

  3. If you also selected Vertically, by filtering the columns of published data on the Filter Data page, on the Filter Table Columns page, select the columns you want to filter from the publication.

  4. In the Filter Table Rows dialog box, click the properties button (...) next to the article that you want to filter, and then complete the WHERE clause using a user-defined function in the condition.