This is just a quick post about a simple why to find out what members are in an Active directory group.
EXEC master.dbo.xp_logininfo'MyDomain\MyGroup','members'
This will tell you what groups a user is in:
EXECÂ master.dbo.xp_logininfo‘MyDomain\MyUser’,‘all’