SQL Server/T-SQL/System/HOST NAME

returns the name of the workstation on which you are working. The syntax for the HOST_NAME function is as follows:

 

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