Provides a list of local Microsoft Windows groups or a list of global groups that are defined in a specified Windows domain.
Applies to: SQL Server (SQL Server 2008 through current version).
If domain_name is the name of the Windows-based computer that an instance of SQL Server is running on, or no domain name is specified, xp_enumgroups enumerates the local groups from the computer that is running SQL Server.
xp_enumgroups cannot be used when an instance of SQL Server is running on Windows 98.
The following example lists the groups in the sales domain.
EXEC xp_enumgroups 'sales';