Get Host Name And User Name In SQL Server

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