Hi all:

Does anyone know how to pull domain name and user name of current logged on user from Windows 2000/Xp and put it in a html form or sql db? Everything I try does not work.

Please help!!!! PLEASE

Thanks!

in asp like this (only one user)

name = Request.ServerVariables("logon_user")
Response.Write(name)



if your want to find user login information, which user
is access / login in you sql server, you can find by this query


SELECT Hostname 'Connected User', db_name(dbid) 'Database', Program_Name, Count(Program_Name) 'Connections'
FROM master.dbo.sysprocesses Where HostName <> '' And db_name(dbid) <> 'master'
Group By Hostname, db_name(dbid), Program_Name


regards

Mateen

Thannks!!!!!