Метод Server.EnumWindowsDomainGroups

Статья
07/14/2013

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

Пространство имен: Microsoft.SqlServer.Management.Smo
Сборка: Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
Public Function EnumWindowsDomainGroups As DataTable
'Применение
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

Возвращаемое значение

Тип: 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.

Примеры

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