ListMembers Method (SQLServer)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The ListMembers method returns a NameList object that enumerates the Microsoft SQL Server server or database roles in which the SQLServer object login has membership.
Syntax
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.