Returns the current host computer name of the client process.
host_name()
select host_name()
------------------------------ violet
host_name, a system function, returns the current host computer name of the client process (not the Server process).
For general information about system functions, see “System functions”.
SQL92 – Compliance level: Transact-SQL extension.
Any user can execute host_name.
Function host_id