selecting the network address in sql

I think you hostname in the sysprocesses in the master db. Check out this
(sql server 2000) query:

SELECT p.spid
,convert(char(12), d.name) db_name
, program_name
, convert(char(12), l.name) login_name
, convert(char(12), hostname) hostname
, cmd
, p.status
, p.blocked
, login_time
, last_batch
, p.spid
FROM master..sysprocesses p
JOIN master..sysdatabases d ON p.dbid = d.dbid
JOIN master..syslogins l ON p.sid = l.sid
ORDER BY 2,IsNull(Ltrim(program_name),"ZZZZZZZZZ"),4,5

--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions

"sheryl kemp" <dianedinero@aol.com> wrote in message
news:3df65936$1@tnews.web.dev-archive.com...
>
> Does anyone know how to select/locate the network address for a login
connection
> to sql? The network address is found in the 'current activity' portion of
> enterprise manager and I was just wondering how I can select the network
> address with a t-sql statement for a particular login id.
>
> Thanks