Server.EnumWindowsGroupInfo Method (String)
SQL Server 2005
Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of Microsoft SQL Server.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
public DataTable EnumWindowsGroupInfo ( String group )
public function EnumWindowsGroupInfo ( group : String ) : DataTable
Parameters
- group
A String value that specifies a Windows group on which to limit the results.
Return Value
A DataTable system object value that contains a list of Windows groups that have explicitly granted access to the instance of SQL Server. The table describes the different columns of the returned DataTable.|
Column |
Data type |
Description |
|
account name |
String |
The name of the Windows NT user. NT AUTHORITY\SYSTEM, for example. |
|
type |
String |
The type of user. This specifies whether the user is an individual account or a group account. |
|
privilege |
String |
The privilege level assigned to the Windows NT group. |
|
mapped login name |
String |
The SQL Server login account to which the Windows NT group is mapped. |
|
permission path |
String |
The permission path for the Windows NT group. |
'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
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
