1- How to find members of an Active Directory group using SQL Server Management studio (SSMS)
2- How to find members of an Active directory group using T-SQL Script
3- How to find which Active directory group a particular user belong to using T-SQL
--Finding out members of Active Directory Group that is already in SQL Server master.dbo.xp_logininfo 'TECHBROTHERS\SQLDBReader', 'members' --Finding out Active directory group that below user belong to? Exec master.dbo.xp_logininfo 'TECHBROTHERS\gbailey'