Displays the current host computer name of the client process (not the server process).
host_name()
select host_name()
------------------------------ violet
See also Transact-SQL Users Guide.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute host_name.