I am wanting to create a sql query to get the Members of a Active Directory
group. I am using the below code:

SELECT * FROM OPENQUERY( ADSI,
'SELECT Name FROM ''LDAP://DC=DOMAIN,DC=com''
WHERE objectCategory = ''group'' and memberof = ''groupname''')

How ever this dose not work. What I need is basicly to search active
directory and get the logon name if the user is a member of a spacific domain
group.

Any help would be really great.

Thanks