Udostępnij za pośrednictwem


ReplicationServer.EnumCurrentPrincipals Method

Definition

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

public:
 System::Data::DataSet ^ EnumCurrentPrincipals();
public System.Data.DataSet EnumCurrentPrincipals ();
member this.EnumCurrentPrincipals : unit -> System.Data.DataSet
Public Function EnumCurrentPrincipals () As DataSet

Returns

A DataSet object that contains the following columns.

Column Data type Description
db_namesysname Database name.
current_principalsysname The current principal for the mirrored database.
mirroring_roletinyint Current role of the local database plays in the database mirroring session.

1 = Principal

2 = Mirror

NULL = Database is not online.

mirroring_statetinyint 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.

Remarks

This method is used to support replication with database mirroring. For more information, see Database Mirroring and Replication (SQL Server).

Applies to