SQL HOST_ID

SQL HOST_ID is one of the System Function, which will return the Workstation identification number.

The Workstation identification number of SQL HOST_ID is nothing but a Process ID of an application on the client computer that is connecting to SQL Server. The syntax behind this is

HOST_ID()

SQL HOST_ID Example

The below SQL HOST_ID code snippet will show you the SQL Server Workstation identification number.

SELECT HOST_ID() AS 'Workstation Number'