The ListMembers method returns a NameList object that enumerates the Microsoft® SQL Server™ 2000 server or database roles in which the SQLServer object login has membership.
object.ListMembers( Type ) as NameList
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
HRESULT ListMembers(
SQLDMO_ROLE_TYPE Type,
LPSQLDMONAMELIST* ppList);
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 |
A NameList object that enumerates system and user-defined security roles.