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)?
+1
A:
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'
Tim
2008-10-15 09:04:17
A:
Just use SQL-DMO: Replace rolename with your role
exec sp_helprolemember rolename
Ilya Kochetov
2008-10-15 09:04:35