sp_helpgroup System Stored Procedure

Reports information about a group or all groups in the current database.

Syntax

sp_helpgroup [grpname]

where

grpname

Is the name of a group created by sp_addgroup in the current database.

Remarks

When grpname is specified, sp_helpgroup reports on the specified group. If no parameter is supplied, sp_helpgroup reports on all groups in the database.

To get a report on the default group public, enclose the name public in quotation marks because it is a reserved word.

Examples

A.    Help on a Single Group

This example displays information about the hackers group.

sp_helpgroup hackers

B.    Help on All Groups

This example displays information about all groups in the current database.

sp_helpgroup

Permission

Execute permission defaults to the public group.

Table Used

sysusers

See Also