ReplicationServer.EnumCurrentPrincipals Method

Artigo
12/03/2008

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

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Syntax

'Declaration
Public Function EnumCurrentPrincipals As DataSet

public DataSet EnumCurrentPrincipals ()

public:
DataSet^ EnumCurrentPrincipals ()

public DataSet EnumCurrentPrincipals ()

public function EnumCurrentPrincipals () : DataSet

Return Value

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.

Remarks

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

Thread Safety

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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Partilhar via