sysmergepublications (T-SQL)

Contains one row for each merge publication defined in the database. This table is stored in the published database.

Column name Data type Description
publisher sysname Name of the default server.
publisher_db sysname Name of the default Publisher database.
name sysname Name of the publication.
description nvarchar(255) Brief description of the publication.
retention int Retention period, expressed in days, for the entire publication set.
publication_type tinyint Indicates the publication is filtered:
0 = Not filtered
1 = Filtered
pubid uniqueidentifier Unique identification number for this publication; generated when the publication is added.
designmasterid uniqueidentifier Reserved for future use.
parentid uniqueidentifier Indicates the parent publication from which the current peer or subset publication was created (used for hierarchical publishing topologies).
sync_mode tinyint Synchronization mode of this publication:
0 = Native
1 =  Character
allow_push int Indicates whether the publication allows push subscriptions.
allow_pull int Indicates whether the publication allows pull subscriptions.
allow_anonymous int Indicates whether the publication allows anonymous subscriptions.
centralized_conflicts int Indicates whether the conflict records are stored at the Publisher.
status tinyint Reserved for future use.
snapshot_ready tinyint Indicates the snapshot of the publication is ready:
0 = Snapshot is ready for use.
1 = Snapshot is not ready for use.
enabled_for_internet bit Indicates whether the synchronization files for the publication are exposed to the Internet, through FTP and other services.
dynamic_filters bit Indicates whether the publication is filtered on a dynamic property.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.