Select window login

Hello friends

i want to select nt window login (System login) name in sql server 2000.

Like If i am login with vijay name then selected name should be vijay

Regards
Vijay Singh

What kind of authentication are you using now?

Have you tried the environment variable System_User...

Select System_User

Try this select statement in a query window - see what you get. Sometimes it comes back with a DOMAIN attached to the front of the value.