General information
Forum:
Microsoft SQL Server
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?
Thanks in advance
Mace
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only