Server.EnumMembers(RoleTypes) Method

Definition

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. For SDS, there is no concept of server roles. Depending on the connection to the databases, we will get information about membership in the database roles. There are two special database roles in master database in SDS, sds_securityadmin and sds_dbcreator, membership of whose can only be got while connected to master database.

public System.Collections.Specialized.StringCollection EnumMembers (Microsoft.SqlServer.Management.Smo.RoleTypes roleType);
member this.EnumMembers : Microsoft.SqlServer.Management.Smo.RoleTypes -> System.Collections.Specialized.StringCollection
Public Function EnumMembers (roleType As RoleTypes) As StringCollection

Parameters

roleType
RoleTypes

Returns

Remarks

RoleTypes.Server has no meaning for Azure SQL Database connections and will be ignored in that case.

Applies to