Método Server.EnumWindowsDomainGroups

Artigo
07/14/2013

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

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

Sintaxe

'Declaração
Public Function EnumWindowsDomainGroups As DataTable
'Uso
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

Valor de retorno

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.

Exemplos

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]
   }
}