ReplicationMonitor.EnumPublishers2 Method

아티클
12/15/2008

Returns a list of Publishers that use the currently connected server as the Distributor.

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

구문

‘선언
Public Function EnumPublishers2 As DataSet

public DataSet EnumPublishers2 ()

public:
DataSet^ EnumPublishers2 ()

public DataSet EnumPublishers2 ()

public function EnumPublishers2 () : DataSet

반환 값

A DataSet object that contains the following columns.

Column	Data type	Description
publisher	String	Is the name of a Publisher.
distribution_db	String	Is the name of the distribution database used by a given Publisher.
status	Int32	Maximum status of all replication agents associated with publications at this Publisher, which can be one of these values. 1 = Started 2 = Succeeded 3 = In progress 4 = Idle 5 = Retrying 6 = Failed
warning	Int32	Maximum threshold warning generated by a subscription belonging to a publication at this Publisher, which can be the logical OR result of one or more of these values. 1 = Expiration. A subscription to a transactional publication has exceeded the retention period by more than the allowable threshold, as a percentage of the retention period. 2 = Latency. The time taken to replicate data from a transactional Publisher to the Subscriber exceeds the threshold, in seconds. 4 = Mergeexpiration. A subscription to a merge publication has exceeded the retention period by more than the allowable threshold, as a percentage of the retention period. 8 = Mergefastrunduration. The time taken to complete synchronization of a merge subscription exceeds the threshold over a fast network connection, in seconds. 16 = Mergeslowrunduration. The time taken to complete synchronization of a merge subscription exceeds the threshold over a slow or dial-up network connection, in seconds. 32 = Mergefastrunspeed. The delivery rate for rows during synchronization of a merge subscription has failed to maintain the threshold rate over a fast network connection, in rows per second. 64 = Mergeslowrunspeed. The delivery rate for rows during synchronization of a merge subscription has failed to maintain the threshold rate over a slow or dial-up network connection, in rows per second.
publicationcount	Int32	Is the number of publications belonging to the Publisher.

주의

If a Distributor is not installed or the distribution database is not created, this method throws an exception.

The EnumPublishers2 method can only be retrieved by members of the sysadmin fixed server role at the Distributor or by members of the db_owner or replmonitor fixed database roles on the distribution database.

Calling EnumPublishers2 is equivalent to executing sp_replmonitorhelppublisher(Transact-SQL).

The EnumPublishers2 method is available with SQL Server 2005.

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 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

ReplicationMonitor Class
ReplicationMonitor Members
Microsoft.SqlServer.Replication Namespace

다음을 통해 공유