Compartir a través de


ReplicationServer.EnumCurrentPrincipals Method

Returns information for all published databases that are participating in database mirroring.

Espacio de nombres: Microsoft.SqlServer.Replication
Ensamblado: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Sintaxis

'Declaración
Public Function EnumCurrentPrincipals As DataSet
public DataSet EnumCurrentPrincipals ()
public:
DataSet^ EnumCurrentPrincipals ()
public DataSet EnumCurrentPrincipals ()
public function EnumCurrentPrincipals () : DataSet

Valor devuelto

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.

Notas

This method is used to support replication with database mirroring. For more information, see Réplica y creación de reflejo de la base de datos.

Seguridad para subprocesos

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.

Plataformas

Plataformas de desarrollo

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Plataformas de destino

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Vea también

Referencia

ReplicationServer Class
ReplicationServer Members
Microsoft.SqlServer.Replication Namespace