Mace,

AFAIK, it's impossible to do on SQL Server side but you can do that on application (PC) side.


>Is there anyway to obtain the NT Username of for the current session irrespective of wether the have user has connected using trusted security of SQL security.
>
>At the moment, I can only see the Current_User, system_user and session_user which returns the database login name. I need to know that real NT username that established the connection.
>
>If not possible through SQL, can it be done using xp_cmdshell say?