How to tell which windows group login I used when logging in via windows authentication
Windows Authentication in SQL Server doesn't work exactly like that. When you log in as a domain user who has an associated login, but also has access via a domain group that has an associated login, the access is determined by the combined DENY/GRANT permissions and SQL\DB role membership assigned to both the user login and the group login.

There is no concept of being 'logged in' as the group, the group is simply a container to provide access to a collection of domain users based on their membership in this group in Active Directory.

You can check the various access paths for a particular user by running this command:

EXEC xp_logininfo '&lt;DOMAIN\user&gt;', 'all'


This will list out the various access paths for a user, i.e. all the group logins and user logins this Windows account is linked to.