Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
EnumMembers Method
Collapse the table of content
Expand the table of content

Server.EnumMembers Method

Enumerates a list of members of server roles and database roles on the instance of SQL Server.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public StringCollection EnumMembers(
	RoleTypes roleType
)

Parameters

roleType
Type: Microsoft.SqlServer.Management.Smo.RoleTypes
A RoleTypes object value that specifies the type of role of which to limit the results.

Return Value

Type: System.Collections.Specialized.StringCollection
A StringCollection object value that contains a list of members and the roles to which they belong.

Use this method to obtain a list of the members of server roles, database roles, or both.

C#

Server srv = new Server("(local)");
StringCollection sc = srv.EnumMembers(RoleTypes.All);
foreach (String s in sc)
{
   Console.WriteLine(s);
}

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")

$sc = $srv.EnumMembers([Microsoft.SqlServer.Management.Smo.RoleTypes]::All)
foreach ($s in $sc)
{
   Write-Host $s
}

Community Additions

ADD
Show:
© 2015 Microsoft