共用方式為


ReplicationMonitor.EnumPublishers 方法

Returns information on the Publishers that use the monitored Distributor.

命名空間:  Microsoft.SqlServer.Replication
組件:  Microsoft.SqlServer.Rmo (在 Microsoft.SqlServer.Rmo.dll 中)

語法

'宣告
Public Function EnumPublishers As DataSet
'用途
Dim instance As ReplicationMonitor 
Dim returnValue As DataSet 

returnValue = instance.EnumPublishers()
public DataSet EnumPublishers()
public:
DataSet^ EnumPublishers()
member EnumPublishers : unit -> DataSet
public function EnumPublishers() : DataSet

傳回值

型別:System.Data.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.

備註

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.

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

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.

Retrieving EnumPublishers is equivalent to executing sp_helpdistpublisher (Transact-SQL).

請參閱

參考

ReplicationMonitor 類別

Microsoft.SqlServer.Replication 命名空間

其他資源

以程式設計方式監視複寫 (RMO 程式設計)