Know your host id and host name in SQL Server

Abhisek
Posted by Abhisek under Sql Server category on | Views : 7146
HOST_ID() returns the workstation id
SELECT HOST_ID()
-->23

HOST_NAME() returns the process host name
SELECT HOST_NAME()
-->ADATA

Comments or Responses

Posted by: Puneet20884 on: 3/3/2010 Level:Bronze | Status: [Member]
thanks....

Login to post response