Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

xp_enumgroups (Transact-SQL)

Provides a list of local Microsoft Windows groups or a list of global groups that are defined in a specified Windows domain.

Topic link iconTransact-SQL Syntax Conventions

xp_enumgroups [ 'domain_name' ]
'domain_name'

Is the name of the Windows domain for which to enumerate a list of global groups. domain_name is sysname, with a default of NULL.

0 (success) or 1 (failure)

Column name

Data type

Description

group

sysname

Name of the Windows group

comment

sysname

Description of the Windows group provided by Windows

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.

Requires membership in the db_owner fixed database role in the master database, or membership in the sysadmin fixed server role.

The following example lists the groups in the sales domain.

EXEC xp_enumgroups 'sales'
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.