INF: HostName Column Blank for SPID Less Than 51 in SQL Profiler sp_who (272696)

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.

REFERENCES

For more information about SQL Server Profiler usage, please see the "SQL Profiler" topic in SQL Server Books Online.

For more information about SPID values changes in SQL Server 2000, please see the sp_who topic in SQL Server Books Online.