documentation.HELP! Replication Wizard Help Documentation

Specify Filter (<<TABLE>> Keyword)

Replication Wizard Help

previous page next page
Replication Wizard Help

<>_keyword)">Specify Filter (<<TABLE>> Keyword)

Enter only the conditions to be used in the filter. The SELECT <published columns> FROM <<TABLE>> WHERE statement has already been supplied and cannot be modified. Add the necessary filter in the WHERE clause. If you use a table name in the WHERE clause, you must use <<TABLE>> instead of the table name. For example, enter only:

<<TABLE>>.salesrep = SUSER_SNAME()

See Also

Row Filters

previous page start next page

Menu

  • Homepage

Table of contents

  • Select Distributor
  • Specify Administrative Password
  • Specify Snapshot Folder
  • Provide Distribution Database Information
  • Enable Publishers
  • Enable Publication Databases
  • Enable Subscribers
  • Publisher and Distributor Properties, Distributor Tab (Local Distributor)
  • Publisher and Distributor Properties, Distributor Tab (Remote Distributor)
  • Publisher and Distributor Properties, Publishers Tab
  • Publisher and Distributor Properties, Publication Databases Tab
  • Publisher and Distributor Properties, Subscribers Tab
  • Distribution Database Properties, Database Tab (Existing Database)
  • Distribution Database Properties, Database Tab (Creating New Database)
  • Publisher Properties, General Tab
  • Publisher Properties, General Tab (Heterogeneous Publisher)
  • Subscriber Properties, General Tab
  • Subscriber Properties, Schedules Tab
  • Create Publication Wizard, Welcome
  • Choose Publication Database
  • Select Publication Type
  • Updatable Subscriptions, Create Publication Wizard
  • Transform Published Data
  • Specify Subscriber Types
  • Specify Articles
  • Article Issues
  • Customize the Properties of the Publication
  • Filter Data
  • Filter Table Columns
  • Enable Dynamic Filters
  • Generate Filters Automatically
  • Filter Table Rows
  • Specify Filter
  • Specify Filter (<<TABLE>> Keyword)
  • Specify Join Filter
  • Validate Subscriber Information, Create Publication Wizard
  • Optimize Synchronization
  • Allow Anonymous Subscriptions
  • article Properties, General Tab (Snapshot or Transactional Publication)
  • article Properties, General Tab (Merge Publication)
  • article Properties, Snapshot Tab
  • article Properties, Commands Tab
  • article Properties, Resolver Tab
  • article Properties, Identity Range Tab
  • article Properties, Merging Changes Tab
  • Stored Procedure Article Properties, General tab
  • Stored Procedure Article Properties, Other tab
  • View Article Properties, General tab
  • View Article Properties, Snapshot tab
  • User-Defined Function Article Properties, General tab
  • User-Defined Function Article Properties, Snapshot tab
  • Indexed View Article Properties, General tab
  • Indexed View Article Properties, Snapshot tab
  • Push Subscription Wizard, Welcome
  • Choose Subscribers
  • Set Merge/Distribution Agent Location
  • Initialize Subscription
  • Set Subscription Priority
  • Updatable Subscriptions, Subscription Wizards
  • Specify DTS Package
  • Start Required Services
  • Pull Subscription Wizard, Welcome
  • Choose Publication
  • Look for Publication
  • Specify Publication
  • Specify Updating Subscription Login
  • Snapshot Delivery
  • Set Distribution Agent Schedule
  • Set Merge Agent Schedule
  • Allow Anonymous Subscription
  • Specify Subscriber Security
  • publication Properties, General Tab
  • publication Properties, Articles Tab
  • publication Properties, Filter Columns Tab
  • publication Properties, Filter Rows Tab
  • publication Properties, Filter Rows Tab (merge publication)
  • publication Properties, Subscriptions Tab
  • publication Properties, Subscription Options Tab (Snapshot or Transactional Publication)
  • publication Properties, Subscription Options Tab (Merge Publication)
  • publication Properties, Subscription Options Tab (SQL Server 7.0 Transactional Publication)
  • publication Properties, Updatable Tab
  • publication Properties, Snapshot Tab
  • publication Properties, Snapshot Location Tab
  • publication Properties, Publication Access List Tab
  • publication Properties, Status Tab
  • publication Properties, Sync Partners Tab
  • heterogeneous publication Properties, General Tab
  • heterogeneous publication Properties, Subscription Options Tab
  • heterogeneous publication Properties, Subscriptions Tab
  • Choose a Destination, Define Transformation of Published Data Wizard
  • Define Transformations
  • Column Mappings and Transformations
  • DTS Package Location
  • DTS Package Identification
  • Specify Filter Values
  • Specify Snapshot File Location
  • Set Job Schedule
  • Pull Subscription Properties, General Tab
  • Pull Subscription Properties, Synchronization Tab (Snapshot or Transactional Publication)
  • Pull Subscription Properties, Synchronization Tab (Merge Publication)
  • Pull Subscription Properties, Security Tab
  • Pull Subscription Properties, Snapshot Location Tab
  • Pull Subscription Properties, Snapshot Delivery Tab (SQL Server 7.0)
  • Generate SQL Scripts, General Tab
  • Generate SQL Scripts, File Options Tab
  • Agent Profiles
  • Refresh Rate and Settings, General Tab
  • Refresh Rate and Settings, Performance Monitor Tab
  • Replication Monitor - Select Columns, Snapshot Agents Tab
  • Replication Monitor - Select Columns, Log Reader Agents Tab
  • Replication Monitor - Select Columns, Distribution Agents Tab
  • Replication Monitor - Select Columns, Merge Agents Tab
  • Replication Monitor - Select Columns, Transactional Publication View Tab
  • Replication Monitor - Select Columns, Merge Publication View Tab
  • Replication Monitor - Select Columns, Miscellaneous Agents Tab
  • Replication Monitor - Select Columns, Queue Reader Agents Tab
  • Add Column to Replicated Table
  • Validate All Subscriptions
  • Validate Subscriptions
  • Subscription Validation Options
  • Enable Subscriber - ODBC Data Source
  • Enable Subscriber - OLE DB Data Source
  • Compatibility Level Warning
  • Add Distributor to Monitor
  • Run Agent at Subscriber
  • Attach Subscription Database

Get in touch

Submit feedback about this site to:

  • [email protected]

© documentation.help. Design: rehmann.co.