Database.EnumWindowsGroups Method (String)
Enumerates a list of Microsoft Windows groups for a specified group.
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Sintaxis
'Declaración
Public Function EnumWindowsGroups ( _
groupName As String _
) As DataTable
public DataTable EnumWindowsGroups (
string groupName
)
public:
DataTable^ EnumWindowsGroups (
String^ groupName
)
public DataTable EnumWindowsGroups (
String groupName
)
public function EnumWindowsGroups (
groupName : String
) : DataTable
Parámetros
- groupName
A String value that specifies a Windows group name.
Valor devuelto
A DataTable object value that contains Windows group information for the specified group. The table describes the different columns of the returned DataTable.
Column |
Data type |
Description |
Urn |
String |
The URN string that represents the Windows group. |
Name |
String |
The name of the Windows group. |
ID |
The ID value that uniquely identifies the Windows group. |
|
Login |
String |
The login that represents the Windows group in SQL Server. |
IsSystemObject |
The Boolean value that specifies whether the Windows group is a system object. |
|
LoginType |
The type of login. See LoginType. |
|
HasDBAccess |
Boolean |
The Boolean value that specifies whether the Windows group as access to the referenced database. |
Sid |
Int32 |
The login security identifier for the Windows group. |
UserType |
String |
The type of user. See UserType. |
Certificate |
String |
The certificate that the Windows group uses to log on to SQL Server. |
AsymmetricKey |
String |
The asymmetric key that the Windows group uses to log on to SQL Server. |
CreateDate |
DateTime |
The date and time when the Windows group was created. |
DateLastModified |
DateTime |
The date and time when the Windows group was last modified. |
DefaultSchema |
String |
The default schema associated with the Windows group. |
Notas
Texto actualizado:17 de julio de 2006
Este espacio de nombres, clase o miembro solamente se admite en la versión 2.0 de Microsoft .NET Framework.
Ejemplo
The example runs a Server object enumeration method, but extracting the information from the DataTable object is the same for Database enumeration methods.
'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
Seguridad para subprocesos
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Plataformas
Plataformas de desarrollo
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Plataformas de destino
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Vea también
Referencia
Database Class
Database Members
Microsoft.SqlServer.Management.Smo Namespace
Otros recursos
How to: Use an Enumeration Method that Returns a DataTable Object in Visual Basic .NET
How to: Create, Alter, and Remove a Database in Visual Basic .NET
Managing Users, Roles, and Logins
Creating, Altering, and Removing Databases
CREATE DATABASE (Transact-SQL)