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’