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);