Reports information about Windows groups with accounts in the current database.
Transact-SQL Syntax Conventions
sp_helpntgroup [ [ @ntname= ] 'name' ]
[ @ntname = ] ' name '
Is the name of the Windows group.
name is sysname, with a default of NULL. name must be a valid Windows group with access to the current database. If name is not specified, all Windows groups with access to the current database are included in the output.
0 (success) or 1 (failure)
Name of the Windows group.
Group identifier (ID).
Security identifier (SID) of
1 = Windows group has permission to access the database.
To see a list of the SQL Server roles in the current database, use
Requires membership in the
The following example prints a list of the Windows groups with access to the current database.
Did you find this helpful?
( 1500 characters remaining)
Thank you for your feedback