Share via


PublisherMonitor.EnumPublications Method

Definition

Returns information on publications at a monitored Publisher.

public:
 System::Data::DataSet ^ EnumPublications();
public System.Data.DataSet EnumPublications ();
member this.EnumPublications : unit -> System.Data.DataSet
Public Function EnumPublications () As DataSet

Returns

A DataSet object that contains the following columns.

Column Data type Description
publisher_db String Database name.
publication String Publication name.
publication_id Int32 ID of the publication.
publication_type Int32 Type of publication:

0 = Transactional.

1 = Snapshot.

2 = Merge.

independent_agent Boolean Indicates if each subscription to this publication uses its own synchronization agent instance.
immediate_sync Boolean Indicates whether synchronization files are created or re-created each time the Snapshot Agent runs.
allow_push Boolean Indicates whether or not push subscriptions can be created for the given publication.
allow_pull Boolean Indicates whether or not pull subscriptions can be created for the given publication.
allow_anonymous Boolean Indicates whether or not anonymous subscriptions can be created for the given publication.
snapshot_agent String The name of the Snapshot Agent job for the publication.
logreader_agent String The name of the Log Reader Agent job for the published database.
description String Description of the publication.
vendor_name String The name of the vendor if Publisher is not an instance of SQL Server.
queuereader agent String The name of the Queue Reader Agent job for the published database.
thirdparty_options Int32 Specifies if the display of a publication in the Replication folder in SQL Server Management Studio is suppressed:

0 = Display a heterogeneous publication in the Replication folder in SQL Server Management Studio.

1 = Suppress the display a heterogeneous publication in the Replication folder in SQL Server Management Studio.

snapshot_jobid String Unique identifier of the Snapshot Agent job.
num_subscriptions Int32 Number of subscriptions that currently belong to the publication.
num_now_syncing Int32 Number of subscriptions currently being synchronized with the publication.
num_errors Int32 Number of errors that have occurred when synchronizing with the publication.
num_warning Int32 Number of publication monitor threshold warnings that have been generated by this publication.
merge_RunFastDurationThreshold Int32 Threshold for monitoring the duration of merge synchronizations over high-bandwidth local area network (LAN) connections.
WorstWarningDuration Int32 The highest duration of a synchronization run that has generated a warning.
merge_SyncExpireTimeThreshold Int32 Threshold for monitoring for imminent expiration of subscriptions to merge publications.
retention Int32 The retention period of the publication, in hours.
WorstWarningExpiration Int32 The longest expiration of a merge subscription that has generated a warning.

Remarks

You should commit any property changes to the PublisherMonitor object before calling this method because properties of this object may need to be loaded if they have not been loaded already.

The EnumPublications method can only be called by members of the db_owner or replmonitor fixed database roles on the distribution database.

Applies to

See also