January 7, 2003 at 8:57 am
People, where i can find information about this sp? why some hostnames shows the format 'X:hostname', others 'ADM:hostname' and others directly shows 'hostname', whitout any prefix?
TIA!
January 7, 2003 at 9:13 am
Have a look in EM database master. Tjere stored proces or in QA database master type sp_helptext sp_who2
Bye
Gabor
January 7, 2003 at 9:13 am
The system stored procedure, sp_who2 is undocumented, but you will find some info about it in Inside SQL Server 2000 by Kalen Delaney and also some references in the Microsoft Knowledge Base articles (especially on application performance and blocking).
However, realize that the hostname is coming from sysprocesses (you can sp_helptext the sp_who2 stored procedure). The hostname, if I remember right, is passed by the client. I don't see X: or ADM: in my hostnames on the various servers I manage.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
January 7, 2003 at 9:13 am
I have never seen anything like this particularly. The names come from sysprocesses and those names are translated from the connecting machine. Odds are someone has a naming convention where they tack those on when they setup the machine names.
January 7, 2003 at 10:44 am
Not being smart or anything but to answer your question:
select hostname from master.dbo.sysprocesses
Why is it stored in sysprocesses that way - That's a difficult question - Are you familiar with your network - How do all of your clients connect?
If your using DNS only then the name is illegal.
Wins is a different story. I suggest reading: http://www.microsoft.com/ntserver/techresources/commnet/WINS/WINSwp98/WINS01-12.asp
John Zacharkan
John Zacharkan
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply