ReplicationServer.EnumCurrentPrincipals Method
Returns information for all published databases that are participating in database mirroring.
命名空間: Microsoft.SqlServer.Replication
組件: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)
語法
'宣告
Public Function EnumCurrentPrincipals As DataSet
public DataSet EnumCurrentPrincipals ()
public:
DataSet^ EnumCurrentPrincipals ()
public DataSet EnumCurrentPrincipals ()
public function EnumCurrentPrincipals () : 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 複寫和資料庫鏡像.
執行緒安全性
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.
平台
開發平台
如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。
目標平台
如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。
請參閱
參考
ReplicationServer Class
ReplicationServer Members
Microsoft.SqlServer.Replication Namespace