Who is logged in the duration of current connection

  • Thread starter Thread starter Cadburys
  • Start date Start date
C

Cadburys

Hi All

I have an Access FE installed on users pc's (about 100). The BE is a SQL
Express db.

I need to find out who is connected to the SQL Server - what date/time they
connected and what date/time their session ended.

I have read a number of posts on getting a list of current users but is it
possible to keep a historical record of this information?

Ulitimately I need to use the data (total duration connected) for reporting
purposes.

Thank you in advance for any assistance.
 
Cadburys said:
Hi All

I have an Access FE installed on users pc's (about 100). The BE is a SQL
Express db.

I need to find out who is connected to the SQL Server - what date/time
they
connected and what date/time their session ended.

I have read a number of posts on getting a list of current users but is it
possible to keep a historical record of this information?

Ulitimately I need to use the data (total duration connected) for
reporting
purposes.

Thank you in advance for any assistance.
Click to expand...


The SQL Server system stored procedure "sp_who" might be what you need. It's
documented in SQL Server Books Online ...

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/132dfb08-fa79-422e-97d4-b2c4579c6ac5.htm
 
Back
Top