Process in SQL Server 2005

Hi, I am developing an application with vb.net and sql server 2005 express edition. If a user logs in (through the application), I want to query the computer host from sql server 2005 in which the user logs on. Is there any special table or procedure that I can use to achieve this? Thanks.

hi,

ghozan wrote:

Hi, I am developing an application with vb.net and sql server 2005 express edition. If a user logs in (through the application), I want to query the computer host from sql server 2005 in which the user logs on. Is there any special table or procedure that I can use to achieve this? Thanks.

can you please expand on your requirement? I did really not understand what you are looking for..

regards

|||

check system sp ... sp_who or

select *from sys.dm_exec_sessions

Madhu