Mapping Active Directory Group members to SQL Server Roles

My question is I have a SQL Server running on Web Server which is a member of a 2000 Active Directory, I only grant access to the database via Global Groups from the Active Directory. When I log onto the database via Windows Authentication the actual user shows up in the master.dbo.sysprocesses table, I can tell what database that process is going to but not how that user is being translated to the Global Group that was actually given access. I need the actual database user name which is the Global Group name that had permissions granted via user defined database roles so that I can do some pre-processing in an ASP.NET application so that I know what parts of a form are updatable or not.No, a Server Role container for users with a specific set of permission. The group has to be mapped to a principal in SQL Server to be included in a role.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.desql

many-to-many help

I have a many-to-many query that is giving me false positives.
Lets say I have some entitiesTeam Members and Teams. Team Members are onTeams, and they could be in one or many Teams. They are represented in tables thusly:
Team Member:
MemberID
TeamMemberName

Team:
TeamID
TeamName

They are associated in this table:
Association:
TeamID
MemberID

I have teams of the following makeup:
Team1:
John
Mary

Team2:
John
Mary
Susan

Team3:
John
Billy

Lets say I have no idea what the teams are, and someone hands me the names John and Mary and tells me I have to find out the single TeamName associated with these people, and only these people. The query I have constructed so far will give me a false positive on Team2.Hi pinkbear and welcome to TSDN !

can you post the query you have as a start point

Regards Purplesql