How to get Hostname in T-SQL?

Question

I need to save my client's name in related database on SQL Server, and i don't want received it by parameter even i want to insert from stored-procedure.

Answer 1

my problem was solved by using below code in stored-procedure.

SELECT HOST_NAME()

Answer 2

Another good approach would be using sp_who2 system procedure like below. Checkout for the login, hostname, dbname and command column.

exec sp_who2