Metodo Server.EnumWindowsDomainGroups

Articolo
07/13/2013

Enumerates a list of Microsoft Windows group accounts defined on a domain.

Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public Function EnumWindowsDomainGroups As DataTable
'Utilizzo
Dim instance As Server 
Dim returnValue As DataTable 

returnValue = instance.EnumWindowsDomainGroups()

public DataTable EnumWindowsDomainGroups()

public:
DataTable^ EnumWindowsDomainGroups()

member EnumWindowsDomainGroups : unit -> DataTable

public function EnumWindowsDomainGroups() : DataTable

Valore restituito

Tipo: System.Data.DataTable
A DataTable system object value that contains a list of Windows group accounts for the specified domain. The table describes the different columns of the returned DataTable.

Column	Data type	Description
Name	String	The name of the Windows Domain group.
Description	String	A description of the Windows Domain group.

Esempi

Visual Basic

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Call the EnumCollations method and return collation information to DataTable variable.
Dim d As DataTable
'Select the returned data into an array of DataRow.
d = srv.EnumCollations
'Iterate through the rows and display collation details for the instance of SQL Server.
Dim r As DataRow
Dim c As DataColumn
For Each r In d.Rows
    Console.WriteLine("============================================")
    For Each c In r.Table.Columns
        Console.WriteLine(c.ColumnName + " = " + r(c).ToString)
    Next
Next

PowerShell

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

$d = new-object System.Data.Datatable
$d = $srv.EnumCollations

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