Provides a list of local Windows NT - based groups or a list of groups defined in a specified Windows NT domain.
xp_enumgroups [domain_name]
where
The xp_enumgroups extended stored procedure enumerates the global groups in a domain. If domain_name is the name of the Windows NT - based computer on which SQL Server is running, xp_enumgroups enumerates the computer's local groups. If no domain name is specified, the computer's local groups are enumerated.
This example enumerates the groups in the salesdomain domain.
xp_enumgroups salesdomain
Execute permission defaults to the system administrator and can be granted to other users.
| xp_grantlogin | xp_logininfo |
| xp_loginconfig | xp_revokelogin |