Posted by Marcin A. Guzowski on 01/16/07 20:10

jebuskrust@gmail.com wrote:
> Question #2:
>
> Answer: Yes, set up a linked server with your pdc server / active
> directory and use open query to query this information from the linked
> server.
>
> http://www.fits-consulting.de/blog/PermaLink,guid,1e768aef-9ae5-4e60-9dad-2f2e73b00faa.aspx


I found much easier way:
exec master.dbo.xp_logininfo 'DOMAIN\GROUP','members'

It will list all members of desired Windows group*, without the need
of setting up a linked server.

[*] only groups granted access to SQL Server are concerned


--
Best regards,
Marcin Guzowski
http://guzowski.info

[Back to original message]