Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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


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.


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


$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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft