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