Using sql to query the active directory groups of a user

See more:

SQL

Hello Everyone

I am trying to write a query in sql 2008 which will return the current user's groups listed in active directory.

To do so, I have created a linked server to the Active directory and I am connecting to it and even write basic ldap queries. However, I wasn't able to figure out how to write the ldap query which will return the current user's groups from the active directory.

Does anyone know how to write an ldap query like this?

Thanks
Ben