• The xp_logininfo stored procedure can be used to return the members of a domain group.

    A couple years back I wrote a script that combines sys.server_principals and xp_logininfo to return individual domain accounts that have either been explicitly granted sysadmin membership or have inherited sysadmin via domain group membership.

    http://www.sqlservercentral.com/articles/Security/76919/

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho