ADSI Get Users Groups

Giganews Newsgroups
Subject: ADSI Get Users Groups
Posted by:  mfaulcon (mfaulc…@discussions.microsoft.com)
Date: Sun, 10 Aug 2008

I have a linked server setup so that I can query Active Directory and ADAM. I
have veiws for Users and Groups, and have even written a query to return the
members of a given group. The problem is, I need to write the reverse, a sp
to return the groups a given user is a member of.

Does anyone know how to do this? Environment is SQL Server 2005, Win 2K3 R2.

Thanks,
Mark Faulcon

Replies