Get List of users in a sql server role

From: Venkat (tammana_at_inooga.com)
Date: 06/24/05


Date: Fri, 24 Jun 2005 19:27:21 +0530


            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