Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Filter Table Columns

SQL Server 2000

Column filters restrict the columns to be included as part of a snapshot, transactional or merge publication. Column filters can reduce the time it takes to propagate data updates to Subscribers, reduce the storage space needed at the Subscriber, and limit the data in a publication to data that is needed by individual Subscribers.

Select the columns to be included in the publication. In the list of columns in the article, you can check or clear the box to the left of the column name to indicate whether the column is included or excluded from the article.

Columns that are part of the primary key for the table (as indicated by a key icon in place of the check box) cannot be excluded from the publication.

If it is a merge publication or if the snapshot or transactional publication allows immediate updating or queued updating subscriptions, timestamp columns (as indicated by the clock icon in place of the check box) cannot be excluded from the publication.

The following columns cannot be excluded:

Column Type Type of publication and/or options Icon displayed next to column
primary key Transactional publications primary key
timestamp Snapshot or transactional publication that allows immediate updating and/or queued updating clock
uniqueidentifier column Merge publications disabled checkbox
msrepl_tran_version Snapshot or transactional publication that allows immediate updating and/or queued updating disabled checkbox
columns that do not allow NULL and do not have default values
  • Merge publications

  • Snapshot or transactional publication that allows immediate updating and/or queued updating
disabled checkbox

See Also

Column Filters

Show:
© 2015 Microsoft