PublisherMonitor.EnumPublications Method

Articolo
12/15/2008

Returns information on publications at a monitored Publisher.

Spazio dei nomi: Microsoft.SqlServer.Replication
Assembly : Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Sintassi

'Dichiarazione
Public Function EnumPublications As DataSet

public DataSet EnumPublications ()

public:
DataSet^ EnumPublications ()

public DataSet EnumPublications ()

public function EnumPublications () : DataSet

Valore restituito

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.

Osservazioni

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.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.