Microsoft KB Archive/272696

= INF: HostName Column Blank for SPID Less Than 51 in SQL Profiler sp_who =

Article ID: 272696

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q272696



SUMMARY
When you use the Microsoft SQL Server 2000 Profiler tool, sp_who, or you use 'SELECT * FROM SYSPROCESSES' to capture events from a server or to display current connection information, the HostName column is blank when the server process ID (SPID) value is less than 51. HostName is the host or computer name of the client that connects to the SQL Server server. This data column is populated if the host name is provided by the client application.

SQL Server 2000 reserves SPID values from 1 through 50 for internal use, while SPID values 51 or higher represent user sessions. This behavior is expected because the host name displays only for user connections.