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. |