다음을 통해 공유


PublisherMonitor.EnumPublications Method

Returns information on publications at a monitored Publisher.

네임스페이스: Microsoft.SqlServer.Replication
어셈블리: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

구문

‘선언
Public Function EnumPublications As DataSet
public DataSet EnumPublications ()
public:
DataSet^ EnumPublications ()
public DataSet EnumPublications ()
public function EnumPublications () : DataSet

반환 값

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.

주의

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.

스레드 보안

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.

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

PublisherMonitor Class
PublisherMonitor Members
Microsoft.SqlServer.Replication Namespace

관련 자료

How to: Programmatically Monitor Replication (RMO Programming)