Simple method to see what AD Users SQL Server can see in AD Groups
Published February 08, 2021 / by Chris Smith / Leave a CommentCredit: Microsoft StackOverflow user Saranya Kumaran Simple method to see what AD Users SQL Server can see in AD Groups exec xp_logininfo ‘Domain/AD Group’, ‘all’ exec xp_logininfo ‘Domain/AD Group’, ‘members’ Notes: Non ad group first command returns error, second command returns no output Msg 15404, Level 16, State 10, Procedure xp_logininfo, Line 64 [Batch Start […]