SQL Server/T-SQL Tutorial/System Settings/HOST NAME

HOST_NAME and HOST_ID functions give information about which workstation a particular login has come from.

4>
5>
6> SELECT HOST_NAME()
7> GO
--------------------------------------------------------------------------------------------------------------------------------
J
(1 rows affected)
1>