How to determine if the logged on user is a member of an active directory security group?

We are using Windows authenication within our system, and I was wondering how it would be possible to determine if the user conected to the SQL SERVER instance was a member of a particular active directory security group?

Thanks.

Moved to Security...

|||

You can use sys.login_token (http://msdn2.microsoft.com/en-us/library/ms186740.aspx) or xp_logininfo (http://msdn2.microsoft.com/en-us/library/ms190369.aspx) to get that information.

I hope this information helps,

-Raul Garcia

SDE/T

SQL Server Engine