ReplicationServer.EnumCurrentPrincipals Method
Returns information for all published databases that are participating in database mirroring.
Espace de noms: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)
Syntaxe
'Déclaration
Public Function EnumCurrentPrincipals As DataSet
public DataSet EnumCurrentPrincipals ()
public:
DataSet^ EnumCurrentPrincipals ()
public DataSet EnumCurrentPrincipals ()
public function EnumCurrentPrincipals () : DataSet
Valeur de retour
A DataSet object that contains the following columns.
Column |
Data type |
Description |
db_name |
sysname |
Database name. |
current_principal |
sysname |
The current principal for the mirrored database. |
mirroring_role |
tinyint |
Current role of the local database plays in the database mirroring session. 1 = Principal 2 = Mirror NULL = Database is not online. |
mirroring_state |
tinyint |
State of the mirror database and of the database mirroring session. 0 = Suspended 1 = Disconnected 2 = Synchronizing 3 = Pending Failover 4 = Synchronized NULL = Database is not online. |
Notes
This method is used to support replication with database mirroring. For more information, see Réplication et mise en miroir des bases de données.
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