How to get domain group? 1

[ColinM]

How can I get the domain group from a login?
i.e.

DOMAIN\Group is a NT Group Login
DOMAIN\User is a member of this group

when DOMAIN\User logs in I want to be able to identify what group they belong to.
Is this possible in SQL?

Using this:
select user_name() as [User], suser_sname() as Login

gives me an output like this:

User Login
---- -----
dbo DOMAIN\User

 

[fluteplr]

try the extended procedure xp_logoninfo. I can't tell for sure from the documentation but it looks like the permissionpath field will return what you want.