CAPTURING COMPUTER NAME.........

[asociate]

Hi,

I have developed a program which monitors the user status who r logged in and the time they spent on the ERP database.In this erp application when a user logs in it updates the status as '1' in a table and '0' when he logs off.
Is there any way to capture the computer name from where the user is logged in i.e. from which system the user had logged in.
when the system updates the status field as '1' then i should be able to know which system has updated this field to '1'.

Is there any function or query which can help me to find this out.
Iam using MSSQL 7.0

 

[cmmrfrds]

Check out the sysprocesses table in the master database.

 

[tlbroadbent]

You can also use the system function HOST_NAME() to capture the host computer name of the current session.

Declare @host varchar(60)
Select @host=host_name()
Print @host Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.