Retrieve NT user from SQL Server

[kim1]

Hi,

Is it possible to retrieve my NT Username of my Window NT when I connect with a SQL Login in SQL Server?

Thanks for your help.

Kim Kim

 

[AshleyRickards]

I believe it's SUSER_SNAME(). Ashley L Rickards
SQL DBA

 

[kim1]

No, SUSER_SNAME() gives the database username.

Thanks anyway.

Kim Kim

 

[AshleyRickards]

Remove the 's' user_name(). I know it's one of those. Ashley L Rickards
SQL DBA

 

[kim1]

Neither,

I tried it, it is always the database login name or user name, not NT user logged into Window NT.

Thanks.

Kim Kim