Ad

MSSQL2000: Get List Of Role Members

- 1 answer

I know a role name and want to find all users in this role. How do I acheive this in SQL Server 2000 (in the SQL script, not in Management Studio or other tool)?

Ad

Answer

You can use the following stored procedures:

For fixed server roles, the stored procedure is sp_helpsrvrolemember:

exec sp_helpsrvrolemember 'role'

For general roles, the stored procedure is sp_helprolemember:

exec sp_helprolemember 'role'
Ad
source: stackoverflow.com
Ad