EnumDatabaseMirrorWitnessRoles Método (String)

Enumera la lista de roles de testigo del reflejo de la base de datos especificada.

Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
Public Function EnumDatabaseMirrorWitnessRoles ( _
    database As String _
) As DataTable
'Uso
Dim instance As Server
Dim database As String
Dim returnValue As DataTable

returnValue = instance.EnumDatabaseMirrorWitnessRoles(database)

public DataTable EnumDatabaseMirrorWitnessRoles(
    string database
)

public:
DataTable^ EnumDatabaseMirrorWitnessRoles(
    String^ database
)

member EnumDatabaseMirrorWitnessRoles : 
        database:string -> DataTable

public function EnumDatabaseMirrorWitnessRoles(
    database : String
) : DataTable

Parámetros

database
Tipo: System. . :: . .String
Valor String que especifica la base de datos para la que se debe devolver la información de los roles de testigo del reflejo de la base de datos.

Valor devuelto

Tipo: System.Data. . :: . .DataTable
Valor de objeto DataTable que contiene la información de los roles de testigo del reflejo de la base de datos.

Ejemplos

Server srv = new Server("(local)");

DataTable d = srv.EnumDatabaseMirrorWitnessRoles("AdventureWorks2008R2");
foreach (DataRow r in d.Rows)
{
   Console.WriteLine("============================================");
   foreach(DataColumn c in d.Columns)
   {
      Console.WriteLine(c.ColumnName + " = " + r[c].ToString());
   }
}

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")

$d = new-object System.Data.Datatable
$d = $srv.EnumDatabaseMirrorWitnessRoles("AdventureWorks2008R2")

Foreach ($r in $d.Rows)
{
   Write-Host "============================================"
   Foreach ($c in $d.Columns)
   {
      Write-Host $c.ColumnName "=" $r[$c]
   }
}