The following scripts will help you determine if you are a member of a group or role or create a list of group members in SQL Server without having to use SQL Server Management Studio. This is a particularly handy script in determining who might have access to the server through Active Directory groups.
The code below indicates whether the current user is a member
of the specified Microsoft Windows group or SQL Server database role.
A result of 1 = yes
,0 = no
,null = the group or role queried is not valid.
SELECT IS_MEMBER('[group or role]')
The code below will create a list of all the logins that are members
of a group.
@acctname = '[group]',
@option = 'members'