ReplicationMonitor.EnumPublishers ReplicationMonitor.EnumPublishers ReplicationMonitor.EnumPublishers Method

정의

모니터링된 배포자를 사용하는 게시자에 대한 정보를 반환합니다. Returns information on the Publishers that use the monitored Distributor.

public:
 System::Data::DataSet ^ EnumPublishers();
public System.Data.DataSet EnumPublishers ();
Public Function EnumPublishers () As DataSet
반환

다음과 같은 열이 포함된 DataSet 개체입니다. A DataSet object that contains the following columns.

Column Data type Description
name String Name of Publisher.
distribution_db String Distribution database for the specified Publisher.
security_mode Int32 Security mode used by the replication agent in a push subscription to connect to the Publisher.
login String Login name used by the replication agent in a push subscription to connect to the Publisher.
password String Password returned (in simple encrypted form). Password is null for users other than sysadmin.
active Boolean Whether a remote Publisher is using the local server as a Distributor:
working_directory String Name of the working directory.
trusted Boolean If the password is required when the Publisher connects to the Distributor. For Microsoft SQL Server 2005, this should always return 0, which means that the password is required.
thirdparty_flag Boolean Whether the publication is enabled by SQL Server or by a third-party application: false = Oracle, or Oracle Gateway Publisher. true = Publisher has been integrated with SQL Server using a third-party application.
publisher_type String Type of Publisher, which can be one of the following: MSSQLSERVER ORACLE ORACLE GATEWAY
publisher_data_source String Name of the OLE DB data source on the Publisher.
Column Data type Description
name String Name of Publisher.
distribution_db String Distribution database for the specified Publisher.
security_mode Int32 Security mode used by the replication agent in a push subscription to connect to the Publisher.
login String Login name used by the replication agent in a push subscription to connect to the Publisher.
password String Password returned (in simple encrypted form). Password is null for users other than sysadmin.
active Boolean Whether a remote Publisher is using the local server as a Distributor:
working_directory String Name of the working directory.
trusted Boolean If the password is required when the Publisher connects to the Distributor. For Microsoft SQL Server 2005, this should always return 0, which means that the password is required.
thirdparty_flag Boolean Whether the publication is enabled by SQL Server or by a third-party application: false = Oracle, or Oracle Gateway Publisher. true = Publisher has been integrated with SQL Server using a third-party application.
publisher_type String Type of Publisher, which can be one of the following: MSSQLSERVER ORACLE ORACLE GATEWAY
publisher_data_source String Name of the OLE DB data source on the Publisher.

설명

모든 속성 변경 내용을 커밋 해야는 ReplicationMonitor 이 개체의 속성은 되지 않은 경우 로드 이미 로드 되도록 할 수 있으므로이 메서드를 호출 하기 전에 개체입니다.You should commit any property changes to the ReplicationMonitor object before calling this method because properties of this object may need to be loaded if they have not been loaded already.

배포자가 설치 되지 않았거나 배포 데이터베이스가 만들어지지 않습니다, 하는 경우이 메서드는 예외가 throw 됩니다.If a Distributor is not installed or the distribution database is not created, this method throws an exception.

EnumPublishers 메서드의 멤버 에서만 검색할 수는 sysadmin 고정된 서버 역할의 멤버에 의해 배포자는 db_owner 또는 replmonitor 고정된 데이터베이스 역할 또는 게시에 있는 사용자가 배포 데이터베이스에 액세스 목록 ( 배포자를 사용 하는 게시의 친구).The EnumPublishers method can only be retrieved by members of the sysadmin fixed server role at the Distributor, by members of the db_owner or replmonitor fixed database role in the distribution database, or by users in the publication access list (PAL) of a publication that uses the Distributor.

검색 EnumPublishers 를 실행 하는 것과 같습니다 sp_helpdistpublisher (Transact SQL)합니다.Retrieving EnumPublishers is equivalent to executing sp_helpdistpublisher (Transact-SQL).

적용 대상

추가 정보