Retrieving Windows Username

[gavjb]

Hi,

Is it possible to get the UserName of the current user logged onto Windows, as I need this to generate a value for a field in a stored procedure.

Thanks,


Gavin,

 

[SQLDenis]

Like this

select suser_sname()

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gavjb]

thanks, but that just returns the sql user, and I am after the user logged onto windows

 

[macleod1021]

As far as I'm aware the only way to do that is if you're using NT Authentication.

 

[SQLDenis]

>>thanks, but that just returns the sql user, and I am after the user logged onto windows

Then that user is not using windows authentication to connect to SQL server

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gavjb]

From what you are saying it looks like I will need to pass the username from the vb app to the stored procedure, I had hoped to get the amount of parameters down to a minimum oh well

SQLDenis - I am not connection to SQL via Windows Authentication, but what I am trying to do is pass the username to a Stored procedure which will be used in calculating a value.