I want to list the members of an AD group added as a user in SQL Server 2000 (or 2005). xp_logininofo works like a champ for local NT group, but does not like the AD groups.
EXECUTE master.dbo.xp_logininfo 'myserver\RS_Management_Te
this fails with error MSG 8198:
EXECUTE master.dbo.xp_logininfo 'mydomain\NOPHI', 'members'
change the \ to a / and it runs but returns no records.
According to this article on sqlserverpedia.com "It really can not get much more simple than that"
I had a good sql admin query the members from this same AD group on this same server once, but I don't know how it was done.... with xp_logininfo or something else. Our IT group has AD setup so we cannot query it directly. Desperate for this, hope someone can help.