Método PublisherMonitor.EnumPublications
Returns information on publications at a monitored Publisher.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (em Microsoft.SqlServer.Rmo.dll)
Sintaxe
'Declaração
Public Function EnumPublications As DataSet
'Uso
Dim instance As PublisherMonitor
Dim returnValue As DataSet
returnValue = instance.EnumPublications()
public DataSet EnumPublications()
public:
DataSet^ EnumPublications()
member EnumPublications : unit -> DataSet
public function EnumPublications() : DataSet
Valor de retorno
Tipo: System.Data.DataSet
A DataSet object that contains the following columns.
Column |
Data type |
Description |
|---|---|---|
publisher_db |
Database name. |
|
publication |
Publication name. |
|
publication_id |
ID of the publication. |
|
publication_type |
Type of publication: 0 = Transactional. 1 = Snapshot. 2 = Merge. |
|
independent_agent |
Indicates if each subscription to this publication uses its own synchronization agent instance. |
|
immediate_sync |
Indicates whether synchronization files are created or re-created each time the Snapshot Agent runs. |
|
allow_push |
Indicates whether or not push subscriptions can be created for the given publication. |
|
allow_pull |
Indicates whether or not pull subscriptions can be created for the given publication. |
|
allow_anonymous |
Indicates whether or not anonymous subscriptions can be created for the given publication. |
|
snapshot_agent |
The name of the Snapshot Agent job for the publication. |
|
logreader_agent |
The name of the Log Reader Agent job for the published database. |
|
description |
Description of the publication. |
|
vendor_name |
The name of the vendor if Publisher is not an instance of SQL Server. |
|
queuereader agent |
The name of the Queue Reader Agent job for the published database. |
|
thirdparty_options |
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 |
Unique identifier of the Snapshot Agent job. |
|
num_subscriptions |
Number of subscriptions that currently belong to the publication. |
|
num_now_syncing |
Number of subscriptions currently being synchronized with the publication. |
|
num_errors |
Number of errors that have occurred when synchronizing with the publication. |
|
num_warning |
Number of publication monitor threshold warnings that have been generated by this publication. |
|
merge_RunFastDurationThreshold |
Threshold for monitoring the duration of merge synchronizations over high-bandwidth local area network (LAN) connections. |
|
WorstWarningDuration |
The highest duration of a synchronization run that has generated a warning. |
|
merge_SyncExpireTimeThreshold |
Threshold for monitoring for imminent expiration of subscriptions to merge publications. |
|
retention |
The retention period of the publication, in hours. |
|
WorstWarningExpiration |
The longest expiration of a merge subscription that has generated a warning. |
Comentários
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.
Consulte também
Referência
Namespace Microsoft.SqlServer.Replication