I see - you want to find out which groups a particular user is a member of, rather than which users are members of a particular group? That's a bit more difficult, although if you have access to the AD administration tools, it should be fairly easy. The stored procedure will only give information about accounts (users and groups) that have access to SQL Server.

John