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. |
| 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. |
| 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. |
| status | tinyint | Reserved for future use. |
| snapshot_ready | tinyint | Indicates the snapshot of the publication is ready:
0 = Snapshot is 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. |
| 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. |
| 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. |