Select USER_NAME()
Select DB_NAME()
Select Host_Name()

Select
user_name() as 'user_name',
SUSER_NAME() as 'Login_ID',
Host_Name() as 'Work_station'