Getting the SQL User name and not the NT user name

[latwv]

I have nt authentication going on for SQL Server 2000 with Win 2000 server. I have NT User user1 in NT Group group1 and I have a sqluser called domain\group1 which is authenticated for nt group group1. I want a function that brings me back 'domain\group1' when I am logged in as user1. User_Name, User, Current_User and every other user function I could find returns 'domain\user1'

Please help
Thanks in advance.
Lori

 

[cmmrfrds]

suser_sname()

 

[tlbroadbent]

Here is a query that returns the NT Groups that the current user is a member of.

Select LoginName As NTGroupName
from master.dbo.syslogins
Where IS_MEMBER(loginname)=1 Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.