sysmergepublications

Transact-SQL Reference

Transact-SQL Reference

sysmergepublications

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

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:

0 = Conflict records are stored at both the Publisher and at the Subscriber that caused the conflict.
1 = All 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.
snapshot_in_defaultfolder bit Specifies whether snapshot files are stored in the default folder:

0 = Snapshot files are in default folder.
1 = Snapshot files are stored in the location specified by alt_snapshot_folder.

alt_snapshot_folder nvarchar(255) Location of the alternate folder for the snapshot.
pre_snapshot_script nvarchar(255) Pointer to an .sql file that the Merge Agent will run before any of the replication object scripts when applying the snapshot at the Subscriber.
post_snapshot_script nvarchar(255) Pointer to an .sql file that the Merge Agent will run after all the other replication object scripts and data have been applied during an initial synchronization.
compress_snapshot bit Specifies whether the snapshot written to the alt_snapshot_folder location is compressed into the Microsoft® CAB format. 0 specifies that the file is not compressed.
ftp_address sysname Network address of the FTP service for the Distributor. Specifies where publication snapshot files are located for the Merge Agent to pick up, if FTP is enabled.
ftp_port int Port number of the FTP service for the Distributor.
ftp_subdirectory nvarchar(255) Subdirectory of where the snapshot files will be available for the Merge Agent to pick up.
ftp_login sysname Username used to connect to the FTP service.
ftp_password nvarchar(524) User password used to connect to the FTP service.
conflict_retention int Specifies the retention period, in days, for which conflicts are retained. A default of 14 days is assigned before the conflict row is purged from the conflict table.
keep_before_values int Specifies whether synchronization optimization is occurring for this publication:

0 = Synchronization is not optimized, and the partitions sent to all Subscribers will be verified when data changes in a partition.
1 = Synchronization is optimized, and only Subscribers having rows in the changed partition are affected.

allow_subscription_copy bit Specifies whether the ability to copy the subscription database has been enabled. 0 means copying is not allowed.
allow_synctoalternate bit Specifies whether an alternate synchronization partner is allowed to synchronize with this Publisher. 0 means that a synchronization partner is not allowed.
validate_subscriber_info nvarchar(500) List the functions that are being used to retrieve Subscriber information and validate the dynamic filtering criteria on the Subscriber.
ad_guidname sysname Specifies whether the publication is published in the Microsoft® Active Directory™. A valid GUID specifies that the publication is published in the Microsoft Active Directory, and the GUID is the corresponding Active Directory publication object objectGUID. If NULL, the publication is not published in Microsoft Active Directory.
backward_comp_level int Database compatibility level (60, 65, 70, and 80).
max_concurrent_merge int Maximum number of concurrent merge processes. A value of 0 for this property means that there is no limit to the number of concurrent merge processes running at any given time. This property sets a limit as to the number of concurrent merge processes that can be run against a merge publication at one time. If there are more snapshot processes scheduled at the same time than the value allows to run, then the excess jobs will be put into a queue and wait until a currently-running merge process finishes.
max_concurrent_dynamic_snapshots int Maximum number of concurrent dynamic snapshot sessions that can be running against the merge publication. If 0, there is no limit to the maximum number of concurrent dynamic snapshot sessions that can run simultaneously against the publication at any given time. This property sets a limit as to the number of concurrent snapshot processes that can be run against a merge publication at one time. If there are more snapshot processes scheduled at the same time than the value allows to run, then the excess jobs will be put into a queue and wait until a currently-running merge process finishes.