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

2 comments:

  1. Kiran JameelDecember 13, 2021 at 11:51 AM

    Is this a paid topic or do you change it yourself?
    However, stopping by with great quality writing, it's hard to see any good blog today.

    Active Data Studio Crack
    Clip Studio Paint EX Crack

    ReplyDelete
  2. AnonymousApril 17, 2022 at 7:33 PM

    Welcome To Techbrothersit: How To Find Users And Thier Ad Groups In Sql Server - Sql Server Dba Tutorial >>>>> Download Now

    >>>>> Download Full

    Welcome To Techbrothersit: How To Find Users And Thier Ad Groups In Sql Server - Sql Server Dba Tutorial >>>>> Download LINK

    >>>>> Download Now

    Welcome To Techbrothersit: How To Find Users And Thier Ad Groups In Sql Server - Sql Server Dba Tutorial >>>>> Download Full

    >>>>> Download LINK Kz

    ReplyDelete

Subscribe to: Post Comments (Atom)