共用方式為


ReplicationServer.EnumCurrentPrincipals 方法

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

命名空間:  Microsoft.SqlServer.Replication
組件:  Microsoft.SqlServer.Rmo (在 Microsoft.SqlServer.Rmo.dll 中)

語法

'宣告
Public Function EnumCurrentPrincipals As DataSet
'用途
Dim instance As ReplicationServer 
Dim returnValue As DataSet 

returnValue = instance.EnumCurrentPrincipals()
public DataSet EnumCurrentPrincipals()
public:
DataSet^ EnumCurrentPrincipals()
member EnumCurrentPrincipals : unit -> DataSet
public function EnumCurrentPrincipals() : DataSet

傳回值

型別:System.Data.DataSet
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.

備註

This method is used to support replication with database mirroring. For more information, see 資料庫鏡像和複寫 (SQL Server).

請參閱

參考

ReplicationServer 類別

Microsoft.SqlServer.Replication 命名空間