RE: Get List of users in a sql server role

From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 06/24/05


Date: Fri, 24 Jun 2005 07:53:12 -0700

See sp_helprolemember in BOL.

AMB

"Venkat" wrote:

> Can any one tell me the way to get the list of members available
> in a particular database role? I need to get the list of roles available in
> the database and the list of users available under each role.
>
> Can any one give me T-Sql statements to meet my requirement?
>
>
>
> Thanks in advance.
>
>
>
> --
>
> Venkat
>
>
>
>
>
>
>
>