Hi All,

I want to get list of all users in particular role. It can be done by executing
Code:
exec sp_helprolemember 'myRole'
Alas it works only when user that executes that is a member of ‘myRole’.
How to achieve the same (list of all users in particular role) while user that executes that is not in 'myRole' role?

Any suggestions welcome.