ListMembers Method (SQLServer)
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The ListMembers method returns a NameList object that enumerates the Microsoft SQL Server server or database roles in which the SQLServerobject login has membership.
Sintaxis
object
.ListMembers(
Type
)
as
NameList
Parts
object
Expression that evaluates to an object in the Applies To list.Type
Long integer that identifies a SQL Server role type constricting NameList membership as described in Settings.
Prototype (C/C++)
HRESULT ListMembers(
SQLDMO_ROLE_TYPE Type,
LPSQLDMONAMELIST* ppList);
Settings
Use the values enumerated below when setting the Type argument.
Constant |
Value |
Description |
|---|---|---|
SQLDMORole_All |
3 |
List server and database roles in which the connected login is a member. |
SQLDMORole_Database |
2 |
List database roles in which the connected login is a member. |
SQLDMORole_Server |
1 |
List server roles in which the connected login is a member. |
Returns
A NameList object that enumerates system and user-defined security roles.