Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Server.EnumDatabaseMirrorWitnessRoles Method (String)


Enumerates a list of mirror witness roles for the specified database.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public DataTable EnumDatabaseMirrorWitnessRoles(
	string database


Type: System.String

A String value that specifies database for which to return mirror witness roles information.

Return Value

Type: System.Data.DataTable

A DataTable object value that contains the database mirror witness role information.


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

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


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

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

Foreach ($r in $d.Rows)
   Write-Host "============================================"
   Foreach ($c in $d.Columns)
      Write-Host $c.ColumnName "=" $r[$c]
Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft