ReplicationServer.EnumDistributionDatabases Method

Article
12/15/2008

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

Espace de noms: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Syntaxe

'Déclaration
Public Function EnumDistributionDatabases As ArrayList

public ArrayList EnumDistributionDatabases ()

public:
ArrayList^ EnumDistributionDatabases ()

public ArrayList EnumDistributionDatabases ()

public function EnumDistributionDatabases () : ArrayList

Valeur de retour

An ArrayList object containing an array of DistributionDatabase objects.

Notes

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.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

ReplicationServer Class
ReplicationServer Members
Microsoft.SqlServer.Replication Namespace

Partager via