The ListMembers method returns a NameList object enumerating the Microsoft® SQL Server™ server or database roles in which the SQLServer object login has membership.
object.ListMembers( Type ) as NameList
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| Type | Long integer identifying a SQL Server role type constricting NameList membership as described in 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 |
A NameList object enumerating system and user-defined security roles.
HRESULT ListMembers(
SQLDMO_ROLE_TYPE Type,
LPSQLDMONAMELIST* ppList);