Hi,

Thank you very much for your comments and your suggestion.

The stored procedure returns the HostName.

Although it would be a simple exercise to get the IP address for the given HostName, it is beyond the scope of this stored procedure. I intended for the output to be in a familiar form for the DBA, as returned by sp_who2.

The main use for this stored procedure is as a very fast tool to get the top processes using I/O resources.

Thanks,

Mircea