Compartir a través de


ReplicationServer.EnumDistributionDatabases Método

Returns the distribution databases installed when the currently connected instance of Microsoft SQL Server is a Distributor.

Espacio de nombres:  Microsoft.SqlServer.Replication
Ensamblado:  Microsoft.SqlServer.Rmo (en Microsoft.SqlServer.Rmo.dll)

Sintaxis

'Declaración
Public Function EnumDistributionDatabases As ArrayList
'Uso
Dim instance As ReplicationServer 
Dim returnValue As ArrayList 

returnValue = instance.EnumDistributionDatabases()
public ArrayList EnumDistributionDatabases()
public:
ArrayList^ EnumDistributionDatabases()
member EnumDistributionDatabases : unit -> ArrayList
public function EnumDistributionDatabases() : ArrayList

Valor devuelto

Tipo: System.Collections.ArrayList
An ArrayList object containing an array of DistributionDatabase objects.

Comentarios

The EnumDistributionDatabases method can only be called when connected to a Distributor.

DistributionDatabase objects are returned with their properties already loaded.

The EnumDistributionDatabases method can be run by members of the public fixed database role who have access to distribution databases. File-related properties of DistributionDatabase are only loaded for members of the db_owner or replmonitor fixed database role on the distribution database and for users in the publication access list (PAL) for any publication whose Publisher is associated with this distribution database.

The EnumDistributionDatabases method is equivalent to the sp_helpdistributiondb (Transact-SQL) stored procedure.

Vea también

Referencia

ReplicationServer Clase

Espacio de nombres Microsoft.SqlServer.Replication