Server.EnumMembers(RoleTypes) Method

Reference

Definition

Namespace:: Microsoft.SqlServer.Management.Smo

Assembly:: Microsoft.SqlServer.Smo.dll

Package:: Microsoft.SqlServer.SqlManagementObjects v150.18208.0

Package:: Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

StringCollection

Remarks

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

Applies to

Share via