How to Find Users and thier AD groups in SQL Server - SQL Server DBA Tutorial

This video illustrates Following:

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

Script that you can use to find out the Users and their AD Groups in SSMS

--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'


How to Get Users and thier AD groups in SQL Server - SQL Server DBA Tutorial