Get Host Name And User Name In SQL Server

In this blog we learn how to get the host name and logged user name.

Using below query you can get the host name and logged user name.

Syntax

SELECT HOST_NAME() AS Host_Name, SUSER_NAME() [User_Name]

Example