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


SQL Server 2000

Reports information about Microsoft® Windows NT® groups with accounts in the current database.


sp_helpntgroup [ [ @ntname = ] 'name' ]


[@ntname =] 'name'

Is the name of the Windows NT group. name is sysname, with a default of NULL. name must be a valid Windows NT group in the current database. If name is not specified, all Windows NT groups in the current database are included in the output. Specify the name that the Windows NT group is known by in the database (added using sp_grantdbaccess).

Return Code Values

0 (success) or 1 (failure)

Result Sets
Column name Data type Description
NTGroupName sysname Name of the Windows NT group.
NTGroupId smallint Group ID.
SID varbinary(85) Security identifier of NTGroupName.
HasDbAccess int 1 = Windows NT group has permission access to the database.


To see a list of the Microsoft SQL Server™ roles in the current database, use sp_helprole.


Execute permissions default to the public role.


This example prints a list of the Windows NT groups in the current database.

EXEC sp_helpntgroup

See Also




System Stored Procedures

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft. All rights reserved.